fejl i recordset
Hej eksperter.....jeg har denne stump kode:
SQL_7 = "SELECT * FROM svar where svar_type='s' AND id=" & request.querystring("id")
set rs7= conn.execute(SQL_7)
if session("bruger_id") = session("id") then
if not rs7.eof then
response.write "<tr><td></td><td align='left'><table width='360px' cellpadding='0' cellspacing='0'><tr><td width='60px'><form name='accepter' method='post'><select name='svarid2' size='" & rs_count("ialt") & "'>"
do
dim bruger
bruger = rs7("bruger_navn")
dim svarer_id
svarer_id = rs7("id")
response.write "<option value='" & (svarer_id) & "'>" & (bruger) & "</option>"
rs.movenext
loop while not rs7.eof
response.write "</select><input name='sporgeid' value='" & session("bruger_id") & "' type='hidden'<input name='point' value='" & session("point") & "' type='hidden'><input name='spmid' value='" & session("spmid") & "' type='hidden'></td><td width='40px' style='padding-left: 3px' align='left'><input type='button' onclick='tjeck()' name='Accepter' value='Accepter'></td><td style='padding-left: 3px' align='left' width='40px'><input type='button' onclick='tjeck2()' name='Afvis' value='Afvis'></td><td width='220px'></form></td></tr></table></td></tr>"
response.write "<tr><td colspan='2' height='10px'><img src='tabbulator.gif' width='501' height='2'></td></tr>"
end if
end if
men, den stopper efter den første select ? hvad gør jeg galt ?
mvh.
www.questis.dk
