<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% Dim Recordset1__MMColParam Recordset1__MMColParam = "ing" If (Request("MM_EmptyValue") <> "") Then Recordset1__MMColParam = Request("MM_EmptyValue") End If %> <% Dim Recordset1 Dim Recordset1_numRows Set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = MM_SelectLight_STRING Recordset1.Source = "SELECT * FROM Supplier WHERE Groups LIKE '%" + Replace(Recordset1__MMColParam, "'", "''") + "%' ORDER BY Company ASC" Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 1 Recordset1.Open() Recordset1_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 Recordset1_numRows = Recordset2_numRows + Repeat1__numRows %> <% Dim Repeat2__numRows Dim Repeat2__index Repeat2__numRows = -1 Repeat2__index = 0 Recordset1_numRows = Recordset1_numRows + Repeat2__numRows %> Select Electrical Wholesale Suppliers and Stockists


Select stock and or distribute products from the following major lighting suppliers.



To select Suppliers By Category:
Commercial Lighting
Indoor
Decorative
Emergency
LED
Outdoor
Low Energy
Bathroom
<% While ((Repeat2__numRows <> 0) AND (NOT Recordset1.EOF)) %> <% Repeat2__index=Repeat2__index+1 Repeat2__numRows=Repeat2__numRows-1 Recordset1.MoveNext() Wend %>
Company
Profile
Label
">
<%=(Recordset1.Fields.Item("Company").Value)%>
<%=(Recordset1.Fields.Item("Profile").Value)%>
<% Recordset1.Close() Set Recordset1 = Nothing %>