Question

参数不足 期待是1，我用的是access数据库，我怀疑是sql语句的错误，请指教

这是我用dreamweaver做网页时生成的代码
<%Dim Recordset1Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")Recordset1.ActiveConnection = MM_data_bbs_STRINGRecordset1.Source = "SELECT * FROM user WHERE name like '" + Replace(Recordset1__usersname, "'", "''") + "'"Recordset1.CursorType = 0Recordset1.CursorLocation = 2Recordset1.LockType = 1Recordset1.Open()
Recordset1_numRows = 0%>
测试网页出现的提示

错误类型：Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 1。/outcome.asp, 第 20 行
浏览器类型：Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; .NET4.0C)
网页：GET /outcome.asp
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_data_bbs_STRING
Recordset1.Source = "SELECT * FROM user WHERE name like '" + Replace(Recordset1__usersname, "'", "''") + "'"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open() /这是第20行/
Recordset1_numRows = 0

Answer 1

往数据库中添加几条数据再试。
“参数不足，期待是1”一般来说出现这种错误很有可能就是sql语句出现错误。比如这么一条语句："select
usermail from user_info where
username='"+username+"'"。首先应先检查下表名是否正确，如果表名没有问题，那一定就是字段弄错了，或者是字段名写错或者表中就
根本没有这个字段名。

Answer 2

请检查 MM_data_bbs_STRING 字符串内容，可能您提供的参数 缺少某一项数据