Entry

How do I populate a combo box with values from a table in a database?

How can I populate e.g.5 drop-down menu all refering to the same table in database? Use a function?

Jul 11th, 2000 19:11
unknown unknown, Nic Chua, Vijay Kumar

you can use do while loop
********************************
<form name="new_price" method="post"
action="new_price.asp">
<TABLE BORDER ="1" bgcolor="#7CCEFA">
   <TR>
     <TD>Pick Up Area</TD>
     <TD>Drop Off Area</TD>
   </TR>
   <TR>
     <td><select name="pick_up_area" class="pulldown">
     <%Set Connect = Server.CreateObject("ADODB.Connection")
     Connect.Open "DSN=xxxxx; UID=xxxx"
     LocationSQL = "SELECT * FROM bcLocation "
     Set rs = Connect.Execute(LocationSQL)   
     WHILE Not rs.EOF%>
     <option value="<%=rs("LOC_CD")%>"><%=rs("DESCRIPTION")%></option>
     <%rs.MoveNext
     Wend    
     %>
     <option selected><%=pick_up%>
     </select>
    </td>
    <td><select name="drop_off_area">
    <%Set rs = Connect.Execute(LocationSQL) 
    WHILE Not rs.EOF%>
    <option value="<%=rs("LOC_CD")%>"><%=rs("DESCRIPTION")%></option>
    <%rs.MoveNext
    Wend    
    rs.Close
    Set Connect = nothing%>
    <option selected><%=drop_off%>
    </select>
    </td>  
  </TR>
</TABLE>
********************************