30. oktober 2006 - 13:41Der er
4 kommentarer og 1 løsning
tjekke om id findes
Hej
Jeg har et lille script hvor jeg udskriver kommentar fra databsen, men for altid denne fejl:
ADODB.Recordset.1 (0x80020009) Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record.
Jeg har skrevet min scriot sådan:
<% set rs_add = server.CreateObject("ADODB.Recordset") rs_add.Open "select * from hot_img_comment where com_img_id='" & min_id & "'", conn
my_id = rs_add("com_user") set get_me = server.CreateObject("ADODB.Recordset") get_me.Open "select mem_username from hot_members where mem_id = '" & my_id & "'", conn
if Not rs_add.eof then do while not rs_add.eof
response.write rs_add("com_text")
rs_add.movenext loop else response.write "Empty" end if %>
<% set rs_add = server.CreateObject("ADODB.Recordset") rs_add.Open "select * from hot_img_comment where com_img_id='" & min_id & "'", conn
if Not rs_add.eof then my_id = rs_add("com_user") set get_me = server.CreateObject("ADODB.Recordset") get_me.Open "select mem_username from hot_members where mem_id = '" & my_id & "'", conn do while not rs_add.eof response.write rs_add("com_text") rs_add.movenext loop else response.write "Empty" end if %>
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.