数据库读取的问题
为什么老是执行到[用户名或密码错误],我的数据库里明明有符合条件的数据存在啊
<%dim rs
UserName=trim(request.form("UserName"))
PassWord=trim(request.form("PassWord"))
set rs=server.CreateObject("ADODB.RecordSet")
sql="select * from Admin where password='"&password&"' and UserName='"& UserName &"'"
'response.write sql
'response.end
rs.open sql, conn,1,1
if rs.eof and rs.bof then
response.write "<script LANGUAGE='javascript'>alert('用户名或密码错误!');history.go(-1);</script>"
response.end
end if
session("admin")=RS("Username")
response.redirect "admin1.asp"
rs.close
rs=nothing
%>