faqts : Computers : Programming : Languages : Asp : ASP/VBScript

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

12 of 20 people (60%) answered Yes
Recently 7 of 10 people (70%) answered Yes

Entry

populate combo boxes from database

Jul 15th, 2003 02:07
Steven S, Kaustav Neogy,


<%strSQL = "SELECT * FROM Library WHERE Author='Joe Doe'"
rs.Open strSQL,Conn,adOpenForwardOnly%>
<select name="sel_Author" id="sel_Author">
<option value="">Make your selection</option>
<%if not rs.EOF = true then
while not rs.EOF=true%>
<option value="<%=rs("Author")%>"><%=rs("Author")%></option>
<%rs.MoveNext
wend
end if
rs.Close
%>
</select>



© 1999-2004 Synop Pty Ltd