fejl i SQL/if
hej eksperter...jeg har denne kode:
if session("brugerID") = rs("bruger_id") then
'vis ikke stemmefunktion
else
sql = "SELECT * FROM tjek WHERE bruger_id=" & Session("brugerID") & " and artikel_id=" & Request.Querystring("id")
set rs = conn.execute(sql)
If adoRec.EOF Then
response.write "<tr><td colspan='2'><hr size='1' color='#000000'></td></tr>"
response.write "<tr><td valign='top' colspan='2'><h2><center><form action='rate.asp?id=" & rs("id") & "' method='post'>1 <input type='radio' name='1' checked value='1'>2 <input type='radio' name='1' value='2'>3 <input type='radio' name='1' value='3'>4 <input type='radio' name='1' value='4'>5 <input type='radio' name='1' value='5'></h2></center></td></tr>"
response.write "<tr><td colspan='2'><center><input type='submit' value='Stem'></center></td></tr>"
response.write "</table>"
else
response.write "</table>"
end if
end if
og få denne fejl:
Microsoft VBScript runtime error '800a01a8'
Object required: 'adoRec'
hvad er der galt ?
mvh.
www.questis.dk
