SELECT CHR_ID FROM IPR_CHARACTERISTIC, IPR_PRODUCT_TYPE WHERE CHR_PT_ID = PT_ID AND CHR_CD_STATUS = 'A' AND PT_CD_STATUS = 'A' AND CHR_PT_ID = #FORM.pt_id# AND CHR_QUERY_FLAG = 'Y' SELECT LV_LOW_VALUE, LV_HIGH_VALUE FROM IPR_LEGAL_VALUE WHERE LV_ID = #Evaluate(arr_Characteristics[Counter][3])# SELECT PC_PRO_ID FROM IPR_PRODUCT_CHARACTERISTICS, IPR_PRODUCT WHERE PC_CD_STATUS = 'A' AND PRO_PT_ID = #FORM.pt_id# AND PC_PRO_ID = PRO_ID AND PC_CHR_ID = #arr_Query[1][1]# #arr_Query[1][3]# AND PC_VALUE LIKE '#arr_Query[1][2]#%' GROUP BY PC_PRO_ID SELECT PC_PRO_ID FROM IPR_PRODUCT_CHARACTERISTICS, IPR_PRODUCT WHERE PC_CD_STATUS = 'A' AND PRO_PT_ID = #FORM.pt_id# AND PC_CHR_ID = #arr_Query[QueryCounter][1]# AND PC_PRO_ID IN ( #ProductList# ) #arr_Query[QueryCounter][3]# AND PC_VALUE LIKE '#arr_Query[QueryCounter][2]#%' GROUP BY PC_PRO_ID SELECT PRO_ID FROM IPR_PRODUCT WHERE PRO_CD_STATUS = 'A' AND PRO_PT_ID = #FORM.pt_id# GROUP BY PRO_ID SELECT PRO_ID FROM IPR_PRODUCT WHERE PRO_CAT_ID = #FORM.cat_id# SELECT PRO_ID, PRO_MODEL, PRO_NAME, PRO_DESCRIPTION FROM IPR_PRODUCT WHERE PRO_ID IN (#ProductList#) GROUP BY PRO_ID, PRO_MODEL, PRO_NAME, PRO_DESCRIPTION SELECT CHR_ID, CHR_NAME FROM IPR_CHARACTERISTIC WHERE CHR_CD_STATUS = 'A' AND CHR_DISPLAY_IN_RESULT_LIST = 'Y' AND CHR_PT_ID = #FORM.pt_id# GROUP BY CHR_ID, CHR_NAME SELECT CHR_ID, PC_PRO_ID, PC_VALUE FROM IPR_PRODUCT_CHARACTERISTICS, IPR_CHARACTERISTIC WHERE CHR_ID = PC_CHR_ID AND PC_CD_STATUS = 'A' AND CHR_CD_STATUS = 'A' AND CHR_DISPLAY_IN_RESULT_LIST = 'Y' AND PC_PRO_ID IN (#ProductList#) AND PC_CHR_ID IN (#ValueList(GetDisplayedCharacteristics.CHR_ID)#) GROUP BY PC_PRO_ID, CHR_ID, PC_VALUE No Records Meet Your Query Criteria SELECT PC_NUMBER_VALUE, PC_VALUE, PC_PRO_ID, PRO_MODEL, PRO_NAME, PRO_DESCRIPTION FROM IPR_PRODUCT_CHARACTERISTICS, IPR_PRODUCT WHERE PC_CD_STATUS = 'A' AND PRO_PT_ID = #FORM.pt_id# AND PC_CHR_ID = #l_SortOrderColumn# AND PC_PRO_ID IN ( #ProductList# ) AND PC_PRO_ID = PRO_ID ORDER BY PC_NUMBER_VALUE ASC, PC_VALUE ASC, PRO_MODEL ASC Jennings Technology Web Site

Query Results- Capacitors

There are no Records that meet your query criteria

There are #GetProductDetail.RecordCount# Products that meet your Query Criteria.

Jennings Capacitance Voltage   Nominal Dimensions Torque
Model Max Min Peak Peak Current Inches Millimeters In.-lbs
Number Test Working Amps Length Diameter Length Diameter Maximum
#l_arr_ProductRow[ProductCounter][2]# #l_arr_ProductRow[ProductCounter][CharacteristicCounter]#  

Home     Contact Us    Site Map     How to Buy
Privacy     Feedback     Terms of Use
Email sales      Email webmaster

(408) 282-0363