I have a hard coded dropdown on my page, but I would like to populate it from a database table instead.
This is my code, and the table name from where I would like to populate it is QueueEnvironment and the two column names are Name, and QueueEnvironmentId. How can I make the option value QueueEnvironmentId correspond to Name in the dropdown?
sql="SELECT distinct(Name) FROM QueueEnvironment order by Name"
Set rsName = AdoCon.Execute(sql)
Do While Not rsName.EOF
Response.Write "<option value=''>"& rsName("Name") &"</option>"