Question

[Microsoft][ODBC Microsoft Access 驱动程序] 参数不足，期待是 1。

<%@ Language="Jscript"%>
<%
T1 = Request("T1")(1);
T2 = Request("T2")(1);

Response.write(T2)

var conn = Server.CreateObject("ADODB.Connection")
conn.Open("driver={Microsoft Access Driver (*.mdb)};dbq="+Server.MapPath("sjk.mdb"));

sql = "select * from user where name ="+T1
//Response.write(sql)

rs = conn.Execute(sql);//错误提示在这一行

Response.write(rs("pwd"));

Response.write("您输入的用户名或密码错误。");

%>

Answer 1

name应该是 char类型的吧，sql="select * from user where name = '"+T1+"'";试试。最好判断一下T1不为null