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 LampType
FROM Products
WHERE LampType IS NOT NULL
AND Product_ID IN (
SELECT Object_ID2
FROM Object_Assn
WHERE Object_Assn.ObjectType2 = 1 AND Object_Assn.Visible = 3
)
ORDER BY LampType
SELECT DISTINCT Name
FROM Products
WHERE Product_ID IN (
SELECT Object_ID2
FROM Object_Assn
WHERE ObjectType2 = 1 AND ObjectType1 = 0 AND Visible = 3
AND Object_ID1 IN (
SELECT Category_ID
FROM Category_Assn
WHERE Parent_ID = 1
)
)
ORDER BY Name
SELECT DISTINCT ProductStyle
FROM Products
WHERE ProductStyle IS NOT NULL AND
Product_ID IN (
SELECT Object_ID2
FROM Object_Assn
WHERE Object_Assn.ObjectType2 = 1 AND Object_Assn.Visible = 3
)
ORDER BY ProductStyle
SELECT DISTINCT InputVoltage
FROM Products
WHERE InputVoltage IS NOT NULL AND
InputVoltage > 1 AND
Product_ID IN (
SELECT Object_ID2
FROM Object_Assn
WHERE Object_Assn.ObjectType2 = 1 AND Object_Assn.Visible = 3
)
ORDER BY InputVoltage
SELECT DISTINCT StartMethod
FROM Products
WHERE StartMethod IS NOT NULL AND
Product_ID IN (
SELECT Object_ID2
FROM Object_Assn
WHERE Object_Assn.ObjectType2 = 1 AND Object_Assn.Visible = 3
)
ORDER BY StartMethod
Search for Ballasts
Select any criteria from the drop down boxes below to search for a ballast.