Drop down box

ChristianX · Mar 22, 2003

Good evening all,
i am stil having persisting problems in trying to
figure out how to create a drop down box that gets its
contents from a database table.

the table i have is called Book: BookID, Title, Publisher

What i want to do is create a drop down box that gets all the
titles from the Book table and put them in the drop down.

Ive only started learning ASP since monday so go easy on me guys!

heres the code ive tried to write so far:


<html>
<head>
<title>Dynamic Drop-Down Menu</title>
</head>

<body>

<%
Dim rsBook
Set rsBook = Server.CreateObject("ADODB.Recordset&quot

rsBook.Open "Book", objConn, adOpenForwardOnly, adLockOptimistic, adCmdTable
Do while not rsBook.EOF
Response.write "<OPTION value= "" & Title & ""></OPTION>"
rsBook.MoveNext
Loop
%>

</body>
</html>

GaryC123 · Mar 22, 2003

Do while not rsBook.EOF
Response.write "<OPTION><%=rs("Title&quot

%></OPTION>"
rsBook.MoveNext
Loop

As you had it it was looking for a variable called Title and not a field in the recordset. Also if the value you want passed is the same as the value that is gonna be inthe drop down you dont need to set a 'value='. You would (or I do) use the value aspect when you want to put a friendly description in the drop down box but the value you want passed is for example a DB field e.g. email is the field name in a database but in the drop down box you want it to say E-Mail so your option tag would look like this
<option value="email">E-Mail</option>

Hope that helps
Saturday 12.00

20.00

3.00am

Sunday [img http

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Drop down box

ChristianX

Programmer

GaryC123

Programmer

Similar threads

Part and Inventory Search

Sponsor