asp(0x80020009)错误

来源:百度知道 编辑:UC知道 时间:2024/09/22 01:56:16
<!--#include file=conn.asp -->
<%
if session("usergroup")="admin" then

set rs=server.createobject("adodb.recordset")
rs.open "select * from member where username='"&username&"'",conn,3,2
rs("posts")=rs("posts")-1
rs("integral")=rs("posts")-1
rs.update
rs.close
set rs=nothing

id=Request.QueryString("id")
delsql="delete from bbs where id="&id
conn.execute(delsql)
conn.close

response.redirect"bbs.asp"
else
response.write "<script language=JavaScript>" & "alert('您不是管理员,无法执行删除操作!');" & "history.back()" & "</script>"
end if
%>

错误类型:
(0x80020009)
发生意外。
/site/bbs_post_del.asp, 第 7 行
改为3后问题依然存在

conn.execute("update member set posts=posts-1,integral=posts-1 where username='"&username&"'")
conn.close
set conn=nothing

rs.open "select * from member where username='"&username&"'",conn,3,2

后面是不是改成 ,conn,3,3 试试

rs("posts")=cint(rs("posts"))-1
rs("integral")=cint(rs("posts"))-1