一个验证会员登录的问题,不知错在那里,请各位大侠帮帮忙
问题是无论我输入正确的帐号和密码还是错误的,都是提示我输入的帐号和密码错误,代码如下,请帮忙看下
<%
uid=trim(request.form("id"))
pwd=trim(request.form("password"))
if len(uid)=0 then
response.Redirect("login.asp")
response.End()
elseif len(pwd)=0 then
response.Redirect("login.asp")
response.End()
End if
set rs=server.CreateObject("ADODB.recordset")
sql="select * from vip where user_id='"&uid&"' and pass_word='"&pwd&"'"
rs.Open sql,objConn,1,1
if rs.bof or rs.eof then
response.write("账号或密码输入错误!<a href='login.asp'>请重新登录</a>")
response.End()
else
session("user_id")=uid
session("create")=rs("user_name")
response.cookies("adminok")=true
response.redirect("index.asp")
response.End()
End if
rs.close
set rs=nothing
objConn.close
set objConn=nothing
%>