<% Set tempConn = Server.CreateObject("ADODB.Connection") strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=F:\home\test.mdb" tempConn.Open strDSN strSQL = "SELECT DISTINCT kategori FROM db ORDER By kategori" Set rsFag = tempConn.Execute(strSQL) Response.Write "<select name=""Kategori"" size=""1"">" Do While Not rsFag.EOF kat = rsFag("kategori") If kat = [den du vil have selected] Then Response.Write "<option value="""& Server.URLEncode(kat)& """ SELECTED>" & kat & "</option>" Else Response.Write "<option value="""& Server.URLEncode(kat)& """>" & kat & "</option>" End If rsFag.MoveNext Loop Response.Write "</select>" tempConn.Close Set tempConn = Nothing %>
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.