Jorgandr gave me this code a while back, but I didn't use it then, because I thought I'd use dtc listboxes instead of manual asp, but I couldn't get them to work, so I used this after all, and it works just great.
It's a little hard to read with all the <%, and I was wondering if there's a neater way to write the same piece. Here it is and thanks for your help.
<SELECT Name="CareerLevel" Size="1">
<%DO UNTIL rsCareerLevel.eof%>
<OPTION Value="<%Response.write rsCareerLevel.fields.getValue("CareerID"
%>"
<%IF rsCareerLevel.fields.getValue("CareerID"
= rsValidatePassword.fields.getValue("CareerLevel"
THEN%>
SELECTED
<%end if%>
><%Response.write rsCareerLevel.fields.getValue("CareerName"
%></OPTION>
<%rsCareerLevel.MoveNext%>
<%loop%>
</SELECT>
It's a little hard to read with all the <%, and I was wondering if there's a neater way to write the same piece. Here it is and thanks for your help.
<SELECT Name="CareerLevel" Size="1">
<%DO UNTIL rsCareerLevel.eof%>
<OPTION Value="<%Response.write rsCareerLevel.fields.getValue("CareerID"
<%IF rsCareerLevel.fields.getValue("CareerID"
SELECTED
<%end if%>
><%Response.write rsCareerLevel.fields.getValue("CareerName"
<%rsCareerLevel.MoveNext%>
<%loop%>
</SELECT>