ASP至少一个参数没有被指定值,请帮忙找找

来源:百度知道 编辑:UC知道 时间:2024/06/30 03:23:32
<!--#include file="conn.asp"-->
<%
atype=Request.form("radio")
user_name=Request.form("user_name")
pass=Request.form("password")
exec="select * from users where atype='"&atype&"' And user_name='"&user_name&"' And pass='"&password&"'"
set rs=server.CreateObject("ADODB.recordset")
rs.open exec,conn,1,1

if (not rs.eof and not rs.bof) then
session("atype")=rs("atype")
session("user_name")=rs("user_name")
response.redirect "../index.asp"
else
response.write "<script language=javascript>alert('对不起,您输入的用户名或密码有误,请重新输入!');history.back(-1);</script>"
end if
%>

exec="select * from users where atype='"&atype&"' And user_name='"&user_name&"' And pass='"&password&"'" '改为

exec="select * from users where atype='"&atype&"' And user_name='"&user_name&"' And pass='"&pass&"'" '应该为pass而不是password
'楼主是否注意到了,你在这裏pass=Request.form("password")

楼上说的不错

pass=Request.form("password")

******** And pass='"&pass&"'"