UC知道在ASP+VBscript+access语法错误 (操作符丢失) 在查询表达式 'ID =' 中）
来源：百度知道 编辑：UC知道 时间：2024/05/10 17:58:08
代码如下：
<%
set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_conn_STRING
Command1.CommandText = "UPDATE zx SET z_dj =z_dj+1 WHERE ID =" + Replace(Command1__up, "'", "''") + " "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()
%>
还有没有其它的办法啊。。谢谢谢谢大家了。
<%
set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_conn_STRING
Command1.CommandText = "UPDATE zx SET z_dj =z_dj+1 WHERE ID =" + Replace(Command1__up, "'", "''") + " "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()
%>
还有没有其它的办法啊。。谢谢谢谢大家了。
操作符丢失的错误有几种.
1;值不对..如果ID是数字..那么. sql语句后面 where 字段="&XX&"
如果是字符串 where 字段='"&XX&"'
2:VB里面"+"表示相加.连接用"&".+作连接的时候.一般在javascript里面;
WHERE ID =" + Replace(Command1__up, "'", "''") + " "
sql=" ......WHERE ID =" &Replace(Command1__up, "'", "''") &" "
WHERE ID =" + Replace(Command1__up, "'", "''") + " "
改为
WHERE ID ='" + Replace(Command1__up, "'", "''") + " "