I have two fields on my db.
One is called CVTypes and the other is called CVNames.
I need to have two dynamic dropdown boxes that allows users to select CV types and CV names from the dropdowns.
How can I do that with this code?
Thanks in advance
Here is code snippet:
set con = server.createobject("ADODB.Connection")
set rs = server.createobject("ADODB.Recordset")
rs.open "SELECT * FROM CVs", con
<OPTION value=none>--Select One--</OPTION>
while not rs.eof
response.write("<OPTION value=" & rs("taskid") & ">")
response.write(rs("CVType") & "</OPTION>")
set rs = nothing
set con = nothing