Question

Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'n_ID =' 中

<%

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_news_STRING
Command1.CommandText = "UPDATE news SET n_hits = n_hits+1 WHERE n_ID = " + Replace(Command1__news_id, "'", "''") + ""
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

%>

Answer 1

变量 Command1__news_id 没有赋值

这段代码是自动增加某个ID的新闻的浏览次数，但是这个ID没有赋值

Answer 2

一个UPDATE就用那么多冗余代码干什么？
用conn.execute("update...")就可以解决的问题
嫌你手指头不累是不
SQL = "UPDATE news SET n_hits = n_hits+1 WHERE n_ID = " + Replace(Command1__news_id, "'", "''")