Question

语法错误 (操作符丢失) 在查询表达式 '编号 in ()' 中。

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_db1_STRING
Command1.CommandText = "DELETE FROM 用户表 WHERE 编号 in (" + Replace(Command1__bb, "'", "''") + ") "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

Command1.Execute()这一行错误...
下面的大哥能说得具体点么.

是错在哪里,,要怎么改,,我新手很笨,说得太深了我不好理解.呵呵,麻烦你再说清楚点.谢谢

Answer 1

打印 Replace(Command1__bb, "'", "''") 你就知道错误了.

具体的SQL语句应该是这样的.

DELETE FROM TABLENAME WHERE ID IN (1,2,3,4,5,6)