faqts : Computers : Programming : Languages : Asp : ASP/VBScript : Common Problems : forms and user input

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

22 of 24 people (92%) answered Yes
Recently 10 of 10 people (100%) answered Yes

Entry

How do I make the first row in a drop down blank and below that all the values from a database?

Jun 14th, 2000 05:30
unknown unknown, Leo Wiedersheim


You could simply leave the 1st option value outside of your recordset 
loop - like so:

<select name="cboItv">
<option value></option>
<%
  While Not Oradynaset.EOF
  If strItv = Cstr(OraDynaset("itv_c")) Then 
%>
<option 
value="<%=OraDynaset("itv_c")%>"Selected><%=OraDynaset("itv_nm")%></opti
on>
<%
  Else
%>
<option 
value="<%=OraDynaset("itv_c")%>"><%=OraDynaset("itv_nm")%> </option>
<%
  End If
  OraDynaset.MoveNext
  Wend
%>
</select>



© 1999-2004 Synop Pty Ltd