rs.update 错误

来源：百度知道 编辑：UC知道 时间：2024/05/03 03:20:20
找到一段程序如下
case "save"
if session("regtimes")=1 then
response.Write "<script language=javascript>alert('您刚注册过用户，请稍后再进行注册！');window.location.reload('reg.asp?action=yes')</script>"
response.End
end if
set rs=server.CreateObject("adodb.recordset")
rs.open "select username,useremail from shop_user where username='"&trim(request("username"))&"' or useremail='"&trim(request("useremail"))&"'",conn,1,1
if not rs.eof and not rs.bof then
response.write "<script language=javascript>alert('该用户名或邮箱重复，请重新输入！');window.location.reload('reg.asp?action=yes')</script>"
response.End
rs.close
else
rs.close
rs.open "select * from shop_user",conn,1,3
rs.addn

在rs.open "select * from shop_user",conn,1,3
前不用加rs.close
看看是不是不存在shop_user这个表阿
先尝试着检索一下，看看行不行

case "save"
if session("regtimes")=1 then
response.Write "<script language=javascript>alert('您刚注册过用户，请稍后再进行注册！');window.location.reload('reg.asp?action=yes')</script>"
response.End
end if
set rs=server.CreateObject("adodb.recordset")
rs.open "select username,useremail from shop_user where username='"&trim(request("username"))&"' or useremail='"&trim(request("useremail"))&"'",conn,1,1
if not rs.eof and not rs.bof then
response.write "<script language=javascript>alert('该用户名或邮箱重复，请重新输入！');window.location.reload('reg.asp?action=yes')</script>"
response.End
,rs.close 去掉
else
'rs.close 去掉
rs.open "select * from s