UC知道语法错误 (逗号) 在查询表达式 'n_id = 6, 11' 中。
来源：百度知道 编辑：UC知道 时间：2024/05/28 11:31:39
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_conn_STRING
Recordset1.Source = "SELECT * FROM ntype WHERE t_id = " + Replace(Recordset1__MMColParam, "'", "''") + ""
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
提示 第 158 行错误，就是Recordset1.Open()，我是新手，请指教？？？？？
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_conn_STRING
Recordset1.Source = "SELECT * FROM ntype WHERE t_id = " + Replace(Recordset1__MMColParam, "'", "''") + ""
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
提示 第 158 行错误，就是Recordset1.Open()，我是新手，请指教？？？？？
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
If (Request.QueryString("t_id") <> "") Then
Recordset1__MMColParam = Request.QueryString("t_id")
End If
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_conn_STRING
Recordset1.Source = "SELECT * FROM ntype WHERE t_id = " + Replace(Recordset1__MMColParam, "'", "''") + ""
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
如果你传递过来的参数是t_id的话（没看到你传递过来的参数）
Recordset1.Source = "SELECT * FROM ntype WHERE t_id in( " + Replace(Recordset1__MMColParam, "'", "''") + ")"
试下。