%
		'=============================================
		' 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
%>
  "
			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
%>
