Question

ASP 验证提交表单出错 提示无效引用 求解决 代码如下：

<%
dim name,password
name=request.form("name")
password=md5(request.form("password"))
Set Rs =.Execute("select top 1 Id,Name,Password,Isdel,LastTime From [User] where name='"&UserName&"' and password='"&Password&"' and (Isdel=0 or Isdel=2)")
If Rs.Eof then
session("name")=rs("name")
session("password")=rs("password")
response.Write("<script>opener.location.reload()</script>")
response.Write("<script>location='IndexHome.asp';</script>")
response.End()
else
response.Write("<script>alert('密码有误!');javascript:history.go(-1)</script>")
response.End()
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>

Answer 1

Set Rs =.Execute("select top 1 Id,Name,Password,Isdel,LastTime From [User] where
多了一个.号
应该是
Set Rs =Execute("select top 1 Id,Name,Password,Isdel,LastTime From [User] where

Answer 2

Set Rs =.Execute("select top 1 Id,Name,Password,Isdel,LastTime From [User] where name='"&UserName&"' and password='"&Password&"' and (Isdel=0 or Isdel=2)")
这行代码出错了，没有连接对象,即conn.execute，conn就是一个连接对象，而连接对象需要被连接正确的数据库

Answer 3

w