Question

asp 参数不足，期待是 1

我做了一个验证窗口，错误提示如下：
错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 1。
/gs/denglu.asp, 第 9 行

浏览器类型：
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)

网页：
POST 38 ??? /gs/denglu.asp

POST Data:
username=a&pwd=a&Submit22=%CC%E1%BD%BB

代码如下，请大家帮我看看
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="connection.asp"-->
<%dim username,pwd
username=request.form("username")
pwd=request.form("pwd")
set rs=server.createobject("adodb.recordset")
exe="select * from user where (username='"&username&"' and pwd='"&pwd&"')"
rs.open exe,conn
if not rs.eof then
rs.Close
conn.Close
session("denglued")="yes"
session("denglu")="right"
session("username")=username
response.Redirect "personindex.htm"
else
session("denglued")="no"
session("denglu")="wrong"
response.Redirect "denglu.htm"
end if
%>

Answer 1

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="connection.asp"-->
<%dim username,pwd
username=request.form("username")
pwd=request.form("pwd")
set rs=server.createobject("adodb.recordset")
exe="select * from user where (username='"&username&"' and pwd='"&pwd&"')"
rs.open exe,conn ，1，1

Answer 2

rs.open exe,conn 1,3
quen:22654343

Answer 3

exe="select * from [user] where (username='"&username&"' and pwd='"&pwd&"')"
rs.open exe,conn,1,1

Answer 4

exe="select * from [user] where (username='"&username&"' and pwd='"&pwd&"')"
rs.open exe,conn,1,3

Answer 5

"rs.open exe,conn "改成
“rs.open exe,conn ,1,3”