
asp 参数不足 期待是2?
参数不足期待是2<%DimRecordset1DimRecordset1_cmdDimRecordset1_numRowsSetRecordset1_cmd=Server...
参数不足 期待是2
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows
Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_coon_STRING
Recordset1_cmd.CommandText = "SELECT * FROM 热点新闻 WHERE banname like ? ORDER BY [key] DESC"
Recordset1_cmd.Prepared = true
Recordset1_cmd.Parameters.Append Recordset1_cmd.CreateParameter("param1", 200, 1, 255, "%" + Recordset1__varinput + "%") ' adVarChar
Set Recordset1 = Recordset1_cmd.Execute 提示是这句有问题Recordset1_numRows = 0 %>
怎么办? 展开
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows
Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_coon_STRING
Recordset1_cmd.CommandText = "SELECT * FROM 热点新闻 WHERE banname like ? ORDER BY [key] DESC"
Recordset1_cmd.Prepared = true
Recordset1_cmd.Parameters.Append Recordset1_cmd.CreateParameter("param1", 200, 1, 255, "%" + Recordset1__varinput + "%") ' adVarChar
Set Recordset1 = Recordset1_cmd.Execute 提示是这句有问题Recordset1_numRows = 0 %>
怎么办? 展开
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询