/*SELECT selectedproducts.discount FROM (distributors INNER JOIN selectedproducts ON distributors.distributorid = selectedproducts.distributorid) INNER JOIN products ON selectedproducts.productid = products.productID WHERE distributors.Subdomain Like 'sysspec' and products.shortname like 'SOLENOID';0.000*/ temporarySolenoidDiscount =0.000; var sol_B3_descrip = "3-Way NEMA 4/4X; Din Cord Grip; Non-NAMUR (fitting mount)"; var sol_B3_weight = 1.00; var sol_B3_price = 86; var sol_E1_descrip = "3-Way Nema 4/4X; potted 1/2 inch Conduit; NAMUR Mount"; var sol_E1_weight = 1.00; var sol_E1_price = 86; var sol_E2_descrip = "3-Way Nema 4/4X/7; potted 1/2 inch Conduit; NAMUR Mount"; var sol_E2_weight = 1.00; var sol_E2_price = 122; var sol_E3_descrip = "3-Way Nema 4/4X Din Cord Grip; NAMUR Mount"; var sol_E3_weight = 1.00; var sol_E3_price = 68; var sol_E4_descrip = "3-Way Nema 4/4X Din; 1/2 inch Conduit; NAMUR Mount"; var sol_E4_weight = 1.00; var sol_E4_price = 77; var sol_E5_descrip = "3-Way Nema 4/4X Din; NAMUR Mount; 6 ft. Cord Set"; var sol_E5_weight = 1.00; var sol_E5_price = 94; var sol_E6_descrip = "3-Way Nema 4/4X Din; NAMUR Mount; 15 ft. Cord Set"; var sol_E6_weight = 1.00; var sol_E6_price = 102; var sol_C1_descrip = "3/4-Way Nema 4/4X; potted 1/2 inch Conduit; NAMUR Mount"; var sol_C1_weight = 1.00; var sol_C1_price = 115; var sol_C2_descrip = "3/4-Way Nema 4/4X/7; potted 1/2 inch Conduit; NAMUR Mount"; var sol_C2_weight = 1.00; var sol_C2_price = 148; var sol_C3_descrip = "3/4-Way Nema 4/4X Din Cord Grip; NAMUR Mount"; var sol_C3_weight = 1.00; var sol_C3_price = 98; var sol_C4_descrip = "3/4-Way Nema 4/4X Din; 1/2 inch Conduit; NAMUR Mount"; var sol_C4_weight = 1.00; var sol_C4_price = 103; var sol_C5_descrip = "3/4-Way Nema 4/4X Din; NAMUR Mount; 6 ft. Cord Set"; var sol_C5_weight = 1.00; var sol_C5_price = 127; var sol_C6_descrip = "3/4-Way Nema 4/4X Din; NAMUR Mount; 15 ft. Cord Set"; var sol_C6_weight = 1.00; var sol_C6_price = 135; var temporaryLimiterDiscount =0.000; var YA_descrip = "2 SPDT, Mechanical, Weatherproof"; var YA_weight = 1.00; var YA_price = 83 ; var YO_descrip = "Explosion Proof Class I, Div II, Proximity Sensor, Clear Lexan Cover"; var YO_weight = 1.00; var YO_price = 534 ; var UA_descrip = "Weatherproof Efector IN0117 AC/DC Non-Contact, 2 NO Contacts"; var UA_weight = 1.00; var UA_price = 220 ; var UB_descrip = "Weatherproof Efector IN5327 DC Non-Contact, 2 NO Contacts"; var UB_weight = 1.00; var UB_price = 204 ; var YE_descrip = "Explosion Proof Class I, Div I, Mechanical Switch, Aluminum Cover"; var YE_weight = 1.00; var YE_price = 369 ; var YH_descrip = "Explosion Proof Class I, Div I, Proximity Sensor, Aluminum Cover"; var YH_weight = 1.00; var YH_price = 573 ; var YF_descrip = "2 SPDT, Mechanical, Weatherproof"; var YF_weight = 1.00; var YF_price = 83 ; var M2_descrip = "M2 2 position mechanical switch (Open & Closed)"; var M2_weight = 1.00; var M2_price = 182 ; var IN0117_descrip = "Weatherproof Efector IN0117 AC/DC Non-Contact, 2 NO Contacts"; var IN0117_weight = 1.00; var IN0117_price = 220 ; var YX_descrip = "Explosion Proof limit Switch, (2) Mechanical SPDT Switches"; var YX_weight = 4.00; var YX_price = 425 ; var IN5327_descrip = "Inductive proximity sensor, 4mm nonflush rectangular housing, two 3-wire PNP, N.O. outputs, Micro DC quick disconnect."; var IN5327_weight = 1.00; var IN5327_price = 151 ; var IN5331_descrip = "Inductive proximity sensor, 4mm nonflush rectangular housing, two 2-wire, N.O. outputs, Micro DC quick disconnect."; var IN5331_weight = 1.00; var IN5331_price = 168 ; var AC2315_descrip = "Dual Inductive Sensor, rectangular plastic housing, 4mm sensing range, non-flush mount, IP67; AS-I version 2.1"; var AC2315_weight = 1.00; var AC2315_price = 246 ; var E18042_descrip = "Cord for UA Switch"; var E18042_weight = 0.50; var E18042_price = 48 ; var EVC002_descrip = "Cord for UD & UE Switch"; var EVC002_weight = 0.50; var EVC002_price = 19 ; var MVLSMKIFM_descrip = "Compact Manual Valve Limit Switch mounting kit"; var MVLSMKIFM_weight = 0.50; var MVLSMKIFM_price = 89 ; var MVLSMKF04_descrip = ""; var MVLSMKF04_weight = 1.00; var MVLSMKF04_price = 75 ; var I4_descrip = "Proximity Switch"; var I4_weight = 0.00; var I4_price = 14 ; var AS_descrip = "ASI Interface"; var AS_weight = 0.00; var AS_price = 217 ; var SM_descrip = "SM Description"; var SM_weight = 2.00; var SM_price = 73 ; var SM_AS_descrip = "SM-AS adder description"; var SM_AS_weight = 0.00; var SM_AS_price = 349 ; var MVLSMKF05_descrip = "MVLS Limit switch F05 mounting"; var MVLSMKF05_weight = 1.00; var MVLSMKF05_price = 78 ; var MVLSMKF07_descrip = "MVLS Limit switch F07 mounting"; var MVLSMKF07_weight = 1.00; var MVLSMKF07_price = 90 ; var MVLSMKF10_descrip = "MVLS Limit switch F10 mounting"; var MVLSMKF10_weight = 1.00; var MVLSMKF10_price = 104 ; var MVLSMKF03_EPV_descrip = "MVLS Limit switch F03 mounting"; var MVLSMKF03_EPV_weight = 1.00; var MVLSMKF03_EPV_price = 109 ; var MVLSMKF04_EPV_descrip = "MVLS Limit switch F04 mounting"; var MVLSMKF04_EPV_weight = 1.00; var MVLSMKF04_EPV_price = 109 ; var MVLSMKF05_EPV_descrip = "MVLS Limit switch F05 mounting"; var MVLSMKF05_EPV_weight = 1.00; var MVLSMKF05_EPV_price = 109 ; var MVLSMKF07_EPV_descrip = "MVLS Limit switch F07 mounting"; var MVLSMKF07_EPV_weight = 1.00; var MVLSMKF07_EPV_price = 128 ; var MVLSMKF10_EPV_descrip = "MVLS Limit switch F10 mounting"; var MVLSMKF10_EPV_weight = 1.00; var MVLSMKF10_EPV_price = 140 ; var temporaryPositionerDiscount =0.000; var P5_descrip = "3-15PSIG input PMV Positioner (w/o gauges)"; var P5_weight = 3.00; var P5_price = 636 ; var E5_descrip = "4-20mADC Input positioners (w/o gauges)"; var E5_weight = 3.00; var E5_price = 1251 ; var EP420_descrip = "EP420 4-20 mADC Electronic Positioner"; var EP420_weight = 3.00; var EP420_price = 1251 ; var EP010_descrip = "EP010 0-10 VDC Electronic Positioner"; var EP010_weight = 3.00; var EP010_price = 1251 ; var E5XP_descrip = "Explosion Proof 4-20mADC Input positioners (w/o gauges)"; var E5XP_weight = 3.00; var E5XP_price = 2063 ; var E6_descrip = "0-10 VDC Input positioners (w/o gauges)"; var E6_weight = 3.00; var E6_price = 101.64 ; var EP420_L_descrip = "EP420-L 4-20 mADC Electronic Positioner"; var EP420_L_weight = 3.00; var EP420_L_price = 2100 ; var EP010_L_descrip = "EP010-L 0-10 VDC Electronic Positioner"; var EP010_L_weight = 3.00; var EP010_L_price = 2100 ; /*asdf*/