% SQL = "SELECT * FROM tblABB" set rs=server.createobject("ADODB.recordset") rs.open SQL,conn %>
Welcome to our interactive online catalogue of products
STEP ONE [Select a part manufacturer]
Select Manufacturer: Please Select <% While (NOT rs.EOF) %> " ><%=(rs.Fields.Item("Manufacturer").Value)%> <% rs.MoveNext() Wend If (rs.CursorType > 0) Then rs.MoveFirst Else rs.Requery End If %>