我voteCount.asp第37行为：Command1.Execute()

Question

其中的update语句为：<%set Command1 = Server.CreateObject("ADODB.Command")Command1.ActiveConnection = MM_connVoteSystem_STRINGCommand1.CommandText = "UPDATE voteItem SET vote_count = vote_count+1, voteitem_id WHERE voteitem_id = " + Replace(Command1__send_id, "'", "''") + " "Command1.CommandType = 1Command1.CommandTimeout = 0Command1.Prepared = trueCommand1.Execute()%>我实在是头疼，找不到错在哪里去掉了之后，就变成这样了：错误类型：Microsoft JET Database Engine (0x80040E14)语法错误 (操作符丢失) 在查询表达式 'voteitem_id =' 中。

Answer 1

Command1.CommandText = "UPDATE voteItem SET vote_count = vote_count+1 WHERE voteitem_id = " + Replace(Command1__send_id, "'", "''") + " "
去掉中间的 , voteitem_id