我刚刚写了一段asp代码,提示错误ERR对象捕捉错误:对象关闭时,操作不被允许,请高手看一下!

来源:百度知道 编辑:UC知道 时间:2024/06/16 23:23:02
if request.QueryString("act")="modify" then
conn.begintrans
rst.open "select * from user where u_id="& id,conn,1,3
rst("u_user")=request.Form("f_user")
rst("u_code")=request.Form("f_code")
rst.update
rst.close
if err.number<>0 then
response.write("ERR对象捕捉错误:"&err.description)
conn.rollbacktrans
response.Write"修改会员失败!"
else
conn.committrans
response.Write"修改会员成功!"
end if
end if

这样就行拉。加上一个rst.addnew
if request.QueryString("act")="modify" then
conn.begintrans
rst.open "select * from user where u_id="& id,conn,1,3
rst.addnew
rst("u_user")=request.Form("f_user")
rst("u_code")=request.Form("f_code")
rst.update
rst.close
if err.number<>0 then
response.write("ERR对象捕捉错误:"&err.description)
conn.rollbacktrans
response.Write"修改会员失败!"
else
conn.committrans
response.Write"修改会员成功!"
end if
end if