在调试ASP网页出现错误
代码为 "ADODB.Recordset '800a0cc1'
在对应所需名称或序数的集合中，未找到项目。"

是怎么回事呢,哪位高手给我解答下

<%@language=vbscript%>
<%
dim conn
set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "DSN=localserver;uid=sa;pwd=;database=database"
conn.open
Set cmd= Server.CreateObject("ADODB.Command")
Set cmd.ActiveConnection = conn
UserName = Request.Form("UserName")
PassWord = Request.Form("PassWord")
If UserName = Empty or PassWord = Empty Then
Response.Write"用户名或密码不能为空！！"
Response.End
Else
sql="select * from xs "
Set rs = Server.CreateObject("ADODB.recordset")
rs.open sql,conn
if rs("UserName")=ZH and rs("PassWord")=MM then
response.redirect "index.asp"
else
response.write"用户名或密码输入错误，请确认!!"
End If
End If
rs.Close
Set rs = Nothing
%>
</script>
帮忙解答下拉

<%
dim conn
set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "DSN=localserver;uid=sa;pwd=;database=database"
conn.open
Set cmd= Server.CreateObject("ADODB.Command")
Set cmd.ActiveConnection = conn
UserName = Request.Form("UserName")
PassWord = Request.Form("PassWord")
If UserName = Empty or PassWord = Empty Then
Response.Write"用户名或密码不能为空！！"
Response.End
Else
sql="select * from xs "
Set rs = Server.CreateObject("ADODB.recordset")
rs.open sql,conn
if rs("UserName")=ZH and rs("PassWord")=MM then
response.redirect "index.asp"
else
response.write"用户名或密码输入错误，请确认!!"
End If
End If
rs.Close
Set rs = Nothing
%>

ZH是数据库表的用户名,MM是密码
这样不就是当获取的用户名和密码跟数据库相同是才可以登陆吗,而且是对应用户名和密码

字段啊

我都试过了,如果象"我不要做斑竹"那样改,就不能检验用户.密码的正确,随便填都可以登陆


sql="select * from xs "
Set rs = Server.CreateObject("ADODB.recordset")
rs.open sql,conn,1,1
if "UserName"=ZH and "PassWord"=MM then
response.redirect "index.asp"
else
response.write"用户名或密码输入错误，请确认!!"

这样就怎么登陆不了,都运行下句

楼上的 ZH,MM 是字段名,

哦,终于做出来了,感谢你们的帮忙,原来我一直忽略了字段的类型,
第一次编程,挺郁闷的但还是有点自豪......