炒饭怎么做好吃视频:懂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了。