为什么出错呢？高手指点一下！

[arclala]

<%
id=request("id")
set rs=server.createobject("adodb.recordset")
sql="delete * from admin where id="&id
rs.open sql,conn,3,3
if rs.eof and rs.bof then
response.write"<SCRIPT language=JavaScript>alert('对不起，该用户不存在或已被删除！');"
response.write"javascript:window.location = 'index.asp';</SCRIPT>"
response.end
else
set rs=nothing
conn.close
set conn=nothing
response.write"<SCRIPT language=JavaScript>alert('OK,该用户已被删除！');"
response.write"javascript:history.go(-1);</SCRIPT>"
end if
%>
调试时总提醒我到“if rs.eof and rs.bof then ”这一行时ADODB.Recordset (0x800A0E78)错误呢？为什么呢？谢谢！

[cfpl]

if (rs.eof and rs.bof) then

[yyy_er]

你删除了以后，查询当然是 eof 了
你把 rs.open sql,conn,3,3 写到 else 下面

[yyy_er]

你删除了以后，查询当然是 eof 了
你把 rs.open sql,conn,3,3 写到 else 下面试试

[popcode]

应该先判断，再删除
<%
id=request("id")
set rs=server.createobject("adodb.recordset")
sql="select * from admin where id="&id
rs.open sql,conn,3,3
if rs.eof or rs.bof then
response.write"<SCRIPT language=JavaScript>alert('对不起，该用户不存在或已被删除！');"
response.write"javascript:window.location = 'index.asp';</SCRIPT>"
response.end
rs.close
set rs=nothing
conn.close
set conn=nothing
else
sql="delete * from admin where id="&id
response.write"<SCRIPT language=JavaScript>alert('OK,该用户已被删除！');"
response.write"javascript:history.go(-1);</SCRIPT>"
end if
conn.close
set conn=nothing
%>

[yyy_er]

哦，搞错了
sql="selete * from admin where id="&id
rs.open sql,conn,1,1
if rs.eof then
...
else
rs.close
sql="delete * from admin where id="&id
rs.open sql,conn,3,3

[ywz413]

if rs.eof and rs.bof then 改为：if rs.eof or rs.bof then