asp错误关于登陆的处理出错如下

最新推荐文章于 2024-09-14 19:44:09 发布

gto889qq

最新推荐文章于 2024-09-14 19:44:09 发布

阅读量257

点赞数

文章标签： asp javascript sql file user

本文链接：https://blog.csdn.net/gto889qq/article/details/6226891

版权

asp错误关于登陆的处理出错如下

----------------------------------------------
Script error detected at line 18.
Source line: rs.open sql,conn,1,1
Description: FROM 子句语法错误。
----------------------------------------------------

<%
uname=trim(request.form("uname"))
upsw=trim(request.form("upsw"))
set rs=server.createobject("ADODB.RECORDSET")
sql="select * from user where username='"&uname&"' and userpsw='"&upsw&"'"
rs.open sql,conn,1,1
if not rs.eof and bof then
response.cookies("admin")=uname
response.redirect "index.asp"
else
response.write " <script language='javascript'>alert('用户名或密码错误!'); location.href='javascript:history.back()'; </script>"
resposne.end
end if
rs.close
set rs=nothing
conn.close
set conn=nothing

'if rs.eof and rs.bof then
'rs.close
'set rs=noting
'conn.close
'set conn=nothing
'response.write" <script language='javascript'>alert('用户名错误!'); location.href='javascript:history.back()'; </script>"
'response.end
'else
' if rs("userpsw") <>upsw then
' rs.close
' set rs=nothing
' conn.close
' set conn=nothing
' response.write" <script language='javascript'>alert('密码有误!'); location.href='javascript:history.go(-1)'; </script>"
' response.end
' else
' response.cookies("admin")=uname
' response.redirect "index.asp"
' response.end
'rs.close
'set rs=nothing
'conn.close
'set conn=nothing
' end if
'end if