I am trying to get values for a drop down list from an SQL database. How do I do this in ASP / vbscript.

My table called 'docmedium' looks like this:

ID Desc
-- ----
1 VHS
2 DVD
3 CD-ROM
4 HDD

I want the Desc values to appear in the drop down list.

Secondly when I save the values in the form back to my master table 'Documents' I want to save the ID and not the Desc. How do I do this.

Cass

You can do using,


strId="<select name='selID'>"
while not rs.eof
  strId=strId & "<option value='" & rs("id") & "'>" & rs("desc") & "</option>"
  rs.movenext
wend
strId=strId & "</select>"


when you submit the form the select control value (ID in this case) is passed. And the user can see desc only.

Thanks You Rajanikrishna. That worked great!:D

Cass