ASP连接SQL的问题,高手帮帮忙。
<html>
<head>
<title>用户验证</title>
</head>
<body bgcolor="#ffffff">
<%
myname=request.form("username")
mypassword=request.form("password")
set connect=server.createobject("adodb.connection")
connect.Provider="sqloledb"
connect.open "Database=xx;UID=xxs;PWD=000"
set rs=server.createobject("adodb.recordset")
rs.open "select * from xxuser where name='xx111'",connect
if rs.eof then
response.write rs("帐号错误")&"<BR>"
else
response.write rs("password")&"<BR>"
end if
rs.close
connect.close
response.write "111"&"<BR>"
set connect=Nothing
%>
===========================================================
数据库里name列有"xx111"的时候没有问题,为什么有没的时候,就出错。不能返回rs.eof。这里应该怎么写呢?