hvad sker der her?
hvordan kan det være at nr 2 drop down boks ligner den er tom? dvs den skriver ikke firmanavnene i boksen selvom den burde...bruger præcis samme stykke kode til den øverste dropdown boks og den virker fint
eksempel her: http://193.89.248.81/reg/ny_ordre.asp
koden kommer her:
<%@ Language=\"VBSCRIPT\" %>
<% Response.buffer = True %>
<%
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\\Inetpub\\db\\register.mdb\"
bSQL = \"SELECT * FROM brugere\"
set rs = Conn.Execute(bSQL)
kSQL = \"SELECT * FROM kunder\"
set rs2 = Conn.Execute(kSQL)
%>
<HTML>
<head>
<title>opret ordre</title>
<link rel=\"stylesheet\" href=\"register.css\">
</head>
<BODY bgcolor=\"#7795A5\" class=\"text\">
<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\">
<tr>
<td bgcolor=\"#0472AA\" class=\"text\">
<font size=\"2\"><b>Opret ny bruger</b></font>
</td></tr>
<tr><td bgcolor=\"#3D6A81\" class=\"text\">
<FORM METHOD=\"POST\" ACTION=\"opret_ordre.asp\">
<b>Bruger:<br>
<select name=\"brugernavn\" class=\'formsearchsmall\' style=\'width: 180px\'>
<option value=\"\" size=\"15\" class=\"formsearchsmall\" style=\"width: 180px\">Vælg bruger</option>
<% Do While not rs.EOF %>
<option value=\"<%=rs(\"brugernavn\")%>\" size=\"15\" class=\"formsearchsmall\" style=\"width: 180px\" ><%=rs(\"brugernavn\")%></option>
<% rs.MoveNext
Loop
%>
</select>
<br><br>
Kunde:<br>
<select name=\"firmanavn\" class=\'formsearchsmall\' style=\'width: 180px\'>
<option value=\"\" size=\"15\" class=\"formsearchsmall\" style=\"width: 180px\">Vælg kunde</option>
<% Do While not rs2.EOF %>
<option value=\"<%=rs2(\"firmanavn\")%>\" size=\"15\" class=\"formsearchsmall\" style=\"width: 180px\"><%=rs2(\"firmanavn\")%></option>
<% rs2.MoveNext
Loop
%>
</select>
<br><br>
Ordre:<br>
<input type=\"text\" name=\"ordrer\" value=\"Ordre\" size=\"15\" class=\"formsearchsmall\" style=\"width: 180px\">
<br><br>
Ordretype:<br>
<input type=\"text\" name=\"ordretype\" value=\"Ordretype\" size=\"15\" class=\"formsearchsmall\" style=\"width: 180px\">
<br><br>
Forventet timeforbrug:<br>
<input type=\"text\" name=\"forvtimeforbrug\" value=\"Forventet timeforbrug\" size=\"15\" class=\"formsearchsmall\" style=\"width: 80px\">
<br><br>
Jobkode:<br>
<input type=\"text\" name=\"jobkode\" value=\"Jobkode\" size=\"15\" class=\"formsearchsmall\" style=\"width: 180px\">
<br><br>
Jobsted:<br>
<input type=\"text\" name=\"jobsted\" value=\"Jobsted\" size=\"15\" class=\"formsearchsmall\" style=\"width: 180px\">
<br><br>
Deadline:<br>
<input type=\"text\" name=\"deadline\" value=\"Deadline\" size=\"15\" class=\"formsearchsmall\" style=\"width: 180px\">
<br><br>
Ordrenr:<br>
<input type=\"text\" name=\"ordrenr\" value=\"Ordrenr\" size=\"15\" class=\"formsearchsmall\" style=\"width: 80px\">
<br><br>
Vis ordre:<br>
<select name=\"visordre\" class=\'formsearchsmall\' style=\'width: 50px\'>
<option value=\"Ja\" size=\"15\" class=\"formsearchsmall\" style=\"width: 50px\">Ja</option>
<option value=\"Nej\" size=\"15\" class=\"formsearchsmall\" style=\"width: 50px\">Nej</option>
</select>
<br><br>
Afsluttet:<br>
<select name=\"afsluttet\" class=\'formsearchsmall\' style=\'width: 50px\'>
<option value=\"Ja\" size=\"15\" class=\"formsearchsmall\" style=\"width: 50px\">Ja</option>
<option value=\"Nej\" size=\"15\" class=\"formsearchsmall\" style=\"width: 50px\">Nej</option>
</select>
<BR><br><br>
</b>
<INPUT TYPE=SUBMIT VALUE=\"Opret\" class=\"formbutton\">
<input type=\"reset\" value=\"slet\" class=\"formbutton\">
</FORM>
</td></tr>
</table>
</BODY>
</HTML>
<%
Conn.Close()
Set Conn = nothing
%>
