Dropdown

Hvis du vil lave en dynamisk dropdown der kører over en database, så kan du gøre sådan her:

<form name="form1" method="post" action="din-side.asp">
<select name="select"
  <%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("dindatabase.mdb")

SQLstmt = "SELECT top 10 overskrift From dintabel where order by id desc"

Conn.Execute (SQLstmt)

Set rs = conn.Execute(SQLstmt)
if rs.EOF then
Response.write ""
else
Do Until rs.EOF%>
<option value="<% response.write rs("overskrift")%>" <% response.write rs("overskrift")%>">
<% response.write rs("overskrift")%>
</option>
<%RS.MoveNext
Loop
end if

Conn.Close
Set Conn = Nothing%>
</select>

takker