how to build an ASP dropdown

gilgalbiblewheel · December 23rd, 2004, 02:05 AM

I want to make a dropdown using a column from my table in the list of the dropdown.

What's wrong with this?

Code:

<form>
<select size="1" name="D1">
  <option VALUE="0" SELECTED>chapter</option><br>

<%Do while not RS.eof
ResponseWrite "<option VALUE="" & chapter & "">chapter</option><br>"

rs.movenext
loop
      ' Exit the loop when reaching the end of the recordset
'If rs.EOF Then Exit For end if
'next
'end if%>
</select></form>

pgtips · December 23rd, 2004, 05:06 AM

You don't seem to be using any columns from your recordset. Also, to have a " at the end of a string you need to add """. Plus you need a . between Response and Write. maybe you want something like this?

Code:

<%Do while not RS.eof
Response.Write "<option value=""" & RS.Fields("ChapterID").Value & """>" & RS.Fields("ChapterName").Value & "</option><br>"

rs.movenext
loop%>

nashnash · December 23rd, 2004, 05:08 AM

<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>

<%

Function MakeCombo()
    set conn=Server.CreateObject("ADODB.Connection")
    conn.Provider="Microsoft.Jet.OLEDB.4.0"
    conn.Open "c:/Nwind.mdb" ' change your connection string here
    set rs=Server.CreateObject("ADODB.recordset")
    rs.Open "Select * from Employees", conn 'change your table name .

    do while not rs.EOF ' before this you can check for eof or bof
        Response.Write"<Option>" &(rs("Title")) &"</option>"
        rs.MoveNext()
    loop
End Function
%>

<select>
    <%MakeCombo()%>
</select>
</BODY>
</HTML>
------------

Thanks
Nash

gilgalbiblewheel · January 17th, 2005, 02:06 PM

ok thanks

Learning of our true origins.

I feel sorry:

http://www.infowars.com/articles/wor...eknowledge.htm

Foreknowledge of A Natural Disaster
Washington was aware that a deadly Tidal Wave was building up in the Indian Ocean