% '============================================= ' create objects on web server 'set cn = server.CreateObject("ADODB.Connection") 'set rs = server.CreateObject("ADODB.Recordset") 'cnString = "DSN=pacific_D30DBCPLS" '============================================= ' get variables from querystring mfg_code = Request("mfg_code") mfg_name = Replace(Request("mfg_name"),"_"," ") PageNo = Request.QueryString("PageNo") '============================================= ' check for manufacturer image Set fs=Server.CreateObject("Scripting.FileSystemObject") If (fs.FileExists("D:\hshome\pacific\pacificlamp.com\product-manufactures\" & mfg_code & ".jpg")) = True Then mfg_img = " " Else mfg_img = "" End If set fs=nothing Select Case mfg_code Case "BEV", "BEVI" extra_categories = "true" main_manufacturer = "Everyready" sub_html = sub_html & "Eveready Battery | " sub_html = sub_html & "Eveready Industrial Battery" Case "MGE", "BGE", "LGE", "XGE", "PGE" extra_categories = "true" main_manufacturer = "General Electric" sub_html = sub_html & "GE Miniature Lamp | " sub_html = sub_html & "GE Ballasts | " sub_html = sub_html & "GE Large Lamps | " sub_html = sub_html & "GE Christmas | " sub_html = sub_html & "GE Photo" Case "BHW", "FHW", "LHW" extra_categories = "true" main_manufacturer = "Howard Ballast" sub_html = sub_html & "Howard Ballast | " sub_html = sub_html & "Howard Fixtures | " sub_html = sub_html & "Howard Large Lamps" Case "BLLT", "ELT" extra_categories = "true" main_manufacturer = "Lutron" sub_html = sub_html & "Lutron Ballast | " sub_html = sub_html & "Lutron Electrical" Case "BSY", "LSY", "PSY", "ESY", "LSYR" extra_categories = "true" main_manufacturer = "Osram / Sylvania" sub_html = sub_html & "Osram/Sylvania Ballast | " sub_html = sub_html & "Osram/Sylvania Large | " sub_html = sub_html & "Osram/Sylvania Photo | " sub_html = sub_html & "Sylvania Electrical | " sub_html = sub_html & "Sylvania Large Retail" Case "PPH", "LPH" extra_categories = "true" main_manufacturer = "Philips" sub_html = sub_html & "Philips Photo | " sub_html = sub_html & "Philips Large" Case "LUS", "PUS" extra_categories = "true" main_manufacturer = "Ushio" sub_html = sub_html & "Large Ushio | " sub_html = sub_html & "Photo Ushio" Case "EST", "LST" extra_categories = "true" main_manufacturer = "Satco" sub_html = sub_html & "Satco Electrical | " sub_html = sub_html & "Satco Large" Case Else End Select %>