Question

ADODB.Field 错误 '800a0bcd'

ADODB.Field 错误 '800a0bcd'

BOF 或 EOF 中有一个是“真”，或者当前的记录已被删除，所需的操作要求一个当前的记录。

/admin/xinxi_del.asp，行 15
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
<!--#include file=conn.asp-->
<!--#include file=cookies.asp-->
<%
id=trim(request("selectedid"))
if trim(id)="" then
response.write "<script language=JavaScript>" & chr(13) & "alert('没有选择记录！');" & "history.back()" & "</script>"
response.end
end if
str2=split(id,",")
set rs=server.createobject("adodb.recordset")
for i=0 to ubound(str2)
sql="select * from [xinxi] where id="&cstr(str2(i))
rs.open sql,conn,1,1
'On Error Resume Next
tupian=rs("tupian")
if tupian<>"0" and tupian<>"" then
fileExt=lcase(right(tupian,4))
if (fileEXT=".gif" or fileEXT=".jpg" or fileEXT=".jpeg") and left(tupian,4)<>"http" then
call deltu()
end if
end if

dim xurl
xurl=server.mappath("\"&rs("xurl")& "")
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
if objFSO.fileExists(xurl) then
objFSO.DeleteFile(xurl)
end if
set objfso=nothing
rs.close

sql="delete from [xinxi] where id="&cstr(str2(i))
rs.open sql,conn,1,3
sql1="delete from [shoucang] where scid='"&cstr(str2(i))&"' "
rs.open sql1,conn,1,3
sql2="delete from [hf] where xxid='"&cstr(str2(i))&"' "
rs.open sql2,conn,1,3
next
sub deltu()
dim whichfile
whichfile=server.mappath("\"& tupian & "")
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
if objFSO.fileExists(whichfile) then
objFSO.DeleteFile(whichfile)
end if
set objfso=nothing
end sub
response.write "<script language=JavaScript>" & chr(13) & "alert('删除信息成功！')</script>"
response.write "<meta http-equiv=refresh content=""1;URL=xinxi.asp"">"
response.end
rs.close
set rs=nothing
closedb
%>
ADODB.Recordset 错误 '800a0e79'

对象打开时，不允许操作。

/admin/xinxi_del.asp，行 36

Answer 1

<!--#include file=conn.asp-->
<!--#include file=cookies.asp-->
<%
id=trim(request("selectedid"))
if trim(id)="" then
response.write "<script language=JavaScript>" & chr(13) & "alert('没有选择记录！');" & "history.back()" & "</script>"
response.end
end if
str2=split(id,",")
set rs=server.createobject("adodb.recordset")
for i=0 to ubound(str2)
sql="select * from [xinxi] where id="&cstr(str2(i))
rs.open sql,conn,1,1
'On Error Resume Next
if not rs.eof then
tupian=rs("tupian")
if tupian<>"0" and tupian<>"" then
fileExt=lcase(right(tupian,4))
if (fileEXT=".gif" or fileEXT=".jpg" or fileEXT=".jpeg") and left(tupian,4)<>"http" then
call deltu()
end if
end if

dim xurl
xurl=server.mappath("\"&rs("xurl")& "")
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
if objFSO.fileExists(xurl) then
objFSO.DeleteFile(xurl)
end if
set objfso=nothing
rs.close
end if
sql="delete from [xinxi] where id="&cstr(str2(i))
rs.open sql,conn,1,3
sql1="delete from [shoucang] where scid='"&cstr(str2(i))&"' "
rs.open sql1,conn,1,3
sql2="delete from [hf] where xxid='"&cstr(str2(i))&"' "
rs.open sql2,conn,1,3
next
sub deltu()
dim whichfile
whichfile=server.mappath("\"& tupian & "")
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
if objFSO.fileExists(whichfile) then
objFSO.DeleteFile(whichfile)
end if
set objfso=nothing
end sub
response.write "<script language=JavaScript>" & chr(13) & "alert('删除信息成功！')</script>"
response.write "<meta http-equiv=refresh content=""1;URL=xinxi.asp"">"
response.end
rs.close
set rs=nothing
closedb
%>