putting values from database into a drop down list

Posted by sushant on Stack Overflow See other posts from Stack Overflow or by sushant
Published on 2010-06-03T09:25:29Z Indexed on 2010/06/03 10:54 UTC
Read the original article Hit count: 143

Filed under:

hi. my tool is in asp. i am using this code for a query in sql

dim req_id
req_id=Request.Form("Req_id")

if req_id<>"" then
Set conn=server.CreateObject("adodb.connection")
                    conn.Open session("Psrconnect")
                    Set rs=CreateObject("Adodb.Recordset")
                    rs.Open "select * from passwords where REQ_ID='"&req_id&"'", conn

i want to put the results of this query into a drop down list. how do i do it? any help is very much appreciated.

© Stack Overflow or respective owner

Related posts about asp-classic