FileUtils = CreateObject("java","com.ablecommerce.ac5.util.FileUtils");
scriptName = FileUtils.getFileName(CGI.SCRIPT_NAME,"/");
AcbConstants = CreateObject("Java","com.ablecommerce.ac5.base.AcbConstants");
lstHeadFoot = wizard.get("HEADFOOT");
strnavside = wizard.get("NAVSIDE");
strheader1 = theme.get("HEADER1");
strheader2 = theme.get("HEADER2");
strfooter2 = theme.get("FOOTER2");
strfooter1 = theme.get("FOOTER1");
SELECT DISTINCT P.Name, P.Product_ID, P.InputVoltage, P.StartMethod, P.PDF, OA.Object_ID1 AS Category_ID
FROM Products P, Object_Assn OA
WHERE P.Product_ID = OA.Object_ID2
AND OA.ObjectType2 = 1
AND OA.Visible = 3
AND P.active = 1
AND P.Name LIKE '#form.ProductTitle#%'
AND P.InputVoltage LIKE '%#form.InputVoltage#%'
and Products.StartMethod LIKE '#form.StartMethod#%'
AND EXISTS
(SELECT plt.lamp_type, plt.product_id
FROM product_lamptype plt
WHERE lamp_type LIKE '%#form.LampType#%'
AND p.product_id = plt.product_id)
AND EXISTS
(SELECT pbt.ballastType, pbt.product_id
FROM product_ballastType pbt
WHERE ballastType LIKE '%#form.ProductStyle#%'
AND p.product_id = pbt.product_id)
AND EXISTS
(SELECT pw.watts, pw.product_id
FROM product_watts pw
WHERE watts LIKE '%#form.watts#%'
AND p.product_id = pw.product_id)
ORDER BY Name