炒饭怎么做好吃视频:懂asp的帮我看一下程序

来源:百度文库 编辑:高考问答 时间:2024/04/28 06:36:41
<%
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 rs.recordcount<>0 then Response.Redirect("users_regform.asp?msg=用户已存在")
rs.close

sql="select top 1 * from [users]"
rs.open sql,conn,1,2
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")&"'"

改什么改,人家做得没错,把0改正1就OK了。