UC知道asp一个简单问题，后台删除出现错误 '800a0bcd' 哪位大哥帮帮忙？
来源：百度知道 编辑：UC知道 时间：2024/06/05 16:01:05
ADODB.Field 错误 '800a0bcd'
BOF 或 EOF 中有一个是“真”，或者当前的记录已被删除，所需的操作要求一个当前的记录。
/cn60165/com_del.asp，行 44
代码如下：
<!--#include file="conn.asp"-->
<!--#include file=cookies.asp-->
<%
dim rs,sql,del_username,sql1,sql2,rs1,id,str2,i,all_id,str1,k,username,sql4,str4,a,sql3,sqllo,rslo
all_id=trim(request("selectedid"))
set rs=server.createobject("adodb.recordset")
str1=split(all_id,",")
for k=0 to ubound(str1)
sql="select id from [jle_xinxi] where username='"&trim(str1(k))&"'"
rs.open sql,conn,1,1
do while not rs.eof
id=id +","&rs("id")&""
rs.movenext
loop
rs.close
str2=split(id,",")
for i=1 to ubound(str2)
sql="delete from [jle_xinxi] where username='"&trim(str1(k))&"'"
BOF 或 EOF 中有一个是“真”，或者当前的记录已被删除，所需的操作要求一个当前的记录。
/cn60165/com_del.asp，行 44
代码如下：
<!--#include file="conn.asp"-->
<!--#include file=cookies.asp-->
<%
dim rs,sql,del_username,sql1,sql2,rs1,id,str2,i,all_id,str1,k,username,sql4,str4,a,sql3,sqllo,rslo
all_id=trim(request("selectedid"))
set rs=server.createobject("adodb.recordset")
str1=split(all_id,",")
for k=0 to ubound(str1)
sql="select id from [jle_xinxi] where username='"&trim(str1(k))&"'"
rs.open sql,conn,1,1
do while not rs.eof
id=id +","&rs("id")&""
rs.movenext
loop
rs.close
str2=split(id,",")
for i=1 to ubound(str2)
sql="delete from [jle_xinxi] where username='"&trim(str1(k))&"'"
建议如下:
1 将以下代码中的rs.open 改成conn.Execute strSql形式:
for i=1 to ubound(str2)
sql="delete from [jle_xinxi] where username='"&trim(str1(k))&"'"
rs.open sql,conn,1,3
sql1="delete from [shoucang] where scid='"&cstr(str2(i))&"' or username='"&trim(str1(k))&"' "
rs.open sql1,conn,1,3
sql2="delete from [hf] where xxid='"&cstr(str2(i))&"' or username='"&trim(str1(k))&"' "
rs.open sql2,conn,1,3
next
sql3="delete from [gbook] where username='"&trim(str1(k))&"' "
rs.open sql3,conn,1,3
call dello()
sql2="delete from [jle_com] where username='"&trim(str1(k))&"' "
rs.open sql2,conn,1,3
2 将程序结构和代码理顺一下
3 过程dello采用参数传递的方式“引用时:dello(trim(str1(k)))”
sub dello(strusr)
set rslo=server.createobject("adodb.recordset&