[Microsoft][ODBC Microsoft Access Driver] 语法错误 (逗号) 在查询表达式 'id = 83, 79' 中。
时间:2011-11-21
来源:互联网
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (逗号) 在查询表达式 'id = 83, 79' 中。
/web/admin/gedanxiugai.asp, 第 105 行
修改页面代码
<%
var Recordset1 = Server.CreateObject("ADODB.Recordset");
Recordset1.ActiveConnection = MM_shujuku_STRING;
Recordset1.Source = "SELECT * FROM 详细 WHERE id = "+ Recordset1__MMColParam.replace(/'/g, "''") + "";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;
%>
在动态表格中第一次能进修改页,第二次就出现错误,,,
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (逗号) 在查询表达式 'id = 83, 79' 中。
/web/admin/gedanxiugai.asp, 第 105 行
修改页面代码
<%
var Recordset1 = Server.CreateObject("ADODB.Recordset");
Recordset1.ActiveConnection = MM_shujuku_STRING;
Recordset1.Source = "SELECT * FROM 详细 WHERE id = "+ Recordset1__MMColParam.replace(/'/g, "''") + "";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;
%>
在动态表格中第一次能进修改页,第二次就出现错误,,,
作者: scanfme 发布时间: 2011-11-21
VB code
Recordset1.Source = "SELECT * FROM 详细 WHERE id in( "+ Recordset1__MMColParam.replace(/'/g, "''") + ")";
作者: yajun_snow 发布时间: 2011-11-21
Recordset1.Source = "SELECT * FROM 详细 WHERE id = "& Recordset1__MMColParam.replace(//g,"''")
或
Recordset1.Source = "SELECT * FROM 详细 WHERE id in ('"&id&"')"
或
Recordset1.Source = "SELECT * FROM 详细 WHERE id in ('"&id&"')"
作者: hefeng_aspnet 发布时间: 2011-11-21
使用 Recordset1.Source = "SELECT * FROM 详细 WHERE id = "& Recordset1__MMColParam.replace(//g,"''")
后出现
Microsoft JScript 编译错误 (0x800A03EE)
缺少 ')'
/web/admin/gedanxiugai.asp, line 102, column 25
Recordset1.CursorType = 0;
------------------------^
后出现
Microsoft JScript 编译错误 (0x800A03EE)
缺少 ')'
/web/admin/gedanxiugai.asp, line 102, column 25
Recordset1.CursorType = 0;
------------------------^
作者: scanfme 发布时间: 2011-11-21
VBScript code
Recordset1.Source = "SELECT * FROM 详细 WHERE id in ("&id&")"
作者: ChengFei_Net 发布时间: 2011-11-21
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28