挑战ASP问题！！ADODB.Recordset (0x800A0BB9)

来源：百度知道 编辑：UC知道 时间：2024/06/04 16:22:14
<!--＃i nclude file="conn.asp"-->
<%
if request("action")="reg" then
set rs=server.createobject("adodb.recordset")
rs.open "select * from user where name='"&trim(request("name"))&"'",conn,1,1
if rs.recordcount>0 then
response.write "<script language='javascript'>window.alert('您输入的用户名已存在，请返回重新输入！');history.back(-1);</script>"
response.end()
end if
sql="select * from user"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
rs.addnew
rs("name")=trim(request.form("name"))
rs("pwd")=trim(request.form("pwd"))
rs("wenti")=trim(request.form("wenti"))
rs("daan")=trim(request.form("daan"))
rs.update
rs.close
set rs=nothing
response.write "<script

好多错误啊，我帮你改一下，你试试看：

<!--#include file="conn.asp"-->
<%
if request("action")="reg" then
username=replace(replace(trim(request("name")),"'","''")," ","")
password=trim(request.form("pwd"))
wenti=trim(request.form("wenti"))
daan=trim(request.form("daan"))
if username="" or password="" or wenti="" or daan="" then
conn.close
set conn=nothing
response.write "<script language=javascript> alert('资料不全，请重新填写！');history.back();</script>"
response.end
end if
set rs=server.createobject("adodb.recordset")
rs.open "select * from [user] where name='"&username&"'",conn,1,3
if not rs.eof then
rs.close
set rs=nothing
conn.close
set conn=nothing
response.write