懂asp的帮我看一下程序

来源:百度知道 编辑:UC知道 时间:2024/05/17 04:54:08
<%
sql="select * from users where u_username="&Request.form("u_username")
rs.open sql,conn,1,1
if rs.recordcount<>0 then Response.Redirect("users_regform.asp?msg=用户已存在")
rs.close

sql="select top 1 * from users"
rs.open sql,conn,0,3
rs.addnew
rs("u_username")=Request.form("u_username")
rs("u_password")=Request.form("password")
rs.update
rs.close
Response.Redirect("index.asp?msg=请登陆")
%>
此行报错

第一句:

sql="select * from users where u_username="&Request.form("u_username")

改为:

sql="select * from users where u_username='"&Request.form("u_username")&"'"

<%
sql="select * from users where u_username="&Request.form("u_username")
rs.open sql,conn,1,1
if rs.recordcount<>0 then Response.Redirect("users_regform.asp?msg=用户已存在")
rs.close

sql="select top 1 * from users"
rs.open sql,conn,1,3
rs.addnew
rs("u_username")=Request.form("u_username")
rs("u_password")=Request.form("password")
rs.update
rs.close
Response.Redirect("index.asp?msg=请登陆")
%>

<%
sql="select * from [users] where u_username='"&Request.form("u_username")&"'"
rs.open sql,conn,1,1
if