日期:2014-05-17  浏览次数:20974 次

对象关闭时,不允许操作。
ADODB.Recordset   错误   '800a0e78 '  

对象关闭时,不允许操作。  

/ok.asp,行   219  


----------------------------------------

if   request( "action ")= "xx_del "   and   request( "xxid ") <> " "   then
                set   rs=Server.CreateObject( "ADODB.Recordset ")
sql= "select   *   from   article   where   id= "&abs(request( "xxid "))
rs.open   sql,conn,1,3
if   rs.eof   then
response.write( " <script> alert( '没有该文章! ');history.go(-1) </script> ")
response.end
end   if
                htmlxd_url=rs( "htmlurl ")
                sch_class_id=rs( "class ")
                sch_city_id=rs( "city ")
                rs.delete
                rs.update
                rs.close
sql= "delete   *   from   reply   where   articleid= "&abs(request( "xxid "))
                rs.open   sql,conn,3,3
                rs.update                                   ------------219行
                rs.close
                set   rs=nothing

                call   sc_class_html(sch_city_id,sch_class_id)

Set   fso   =   Server.CreateObject( "Scripting.FileSystemObject ")
fso.DeleteFile(Server.MapPath( "/ "&web_path& "html/ "&xxsc_Path&htmlxd_url))
fso.DeleteFile(Server.MapPath( "/ "&web_path& "html/hf/hf_ "&abs(request( "xxid "))& ".js "))
fso.close
set   fso=nothing
response.write( " <script> alert( '删除成功! ');this.location.href= 'user_xxgl.asp ' </script> ")
end   if

------解决方案--------------------
rs.close之后重新set rs=Server.CreateObject( "ADODB.Recordset ")即可

------解决方案--------------------
if request( "action ")= "xx_del " and request( "xxid ") <> " " then
set rs=Server.CreateObject( "ADODB.Recordset ")
sql= "select * from article where id= "&abs(request( "xxid "))
rs.open sql,conn,1,3
if rs.eof then
response.write( " <script> alert( '没有该文章! ');history.go(-1) </script> ")
response.end
end if
htmlxd_url=rs( "htmlurl ")
sch_class_id=rs( "class ")
sch_city_id=rs( "city ")
rs.delete
rs.update
rs.close
set rs=Server.CreateObject( "ADODB.Recordset ")———————(加上这个试一下)
sql= "delete * from reply where articleid= "&abs(request( "xxid "))
rs.open sql,conn,3,3
rs.update