Dropdown med flere felter
hvordan får jeg denne kode til at vise 2 felter fra databasen i dropdownboxenkoden er:
<%
Dim conn
Dim rs
Dim strconn
Dim DBQValue
Session(\"DataConn_ConnectionString\") = _
\"DRIVER=Microsoft Access Driver (*.mdb);DBQ=\" & Server.MapPath(\"adresse.mdb\")
strconn = Session(\"DataConn_ConnectionString\")
set conn = server.createobject(\"adodb.connection\")
set rs = server.createobject(\"adodb.recordset\")
conn.open strconn
strsql = \"SELECT * FROM mander\"
rs.open strsql, conn, 2, 2
%>
<html>
<form method=\"POST\" action=\"vis_betalinger.asp?id=<%=rs(\"mander\")%>\">
<head>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1252\">
<meta name=\"GENERATOR\" content=\"Microsoft FrontPage 3.0\">
<title>Søg på betalinger</title>
</head>
<body style=\"background-color: #FFCC00\">
<body>
<% Response.Write \"Vælg hvilken måned du vil se oversigten for\"+ \" \"%>
<select name=\"mander\" size=\"12\">
<% Do While Not rs.EOF %> <option value=\"<% = rs(\"mander\") %>\"><% = rs(\"mander\") %></option>
<% rs.movenext %><% loop %> </select><br><BR><BR>
<%
rs.close
conn.close
set rs = nothing
set conn = nothing
%>
<p><input type=\"submit\" value=\"Send\" name=\"B1\"></p>
</form>
</html>
