主题:一个ASP的UPDATE错误,请各位能否说明,谢了
代码:
<%
set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_vote_STRING
Command1.CommandText = "UPDATE votedbvote SET " + Replace(Command1__kigo, "'", "''") + " = " + Replace(Command1__kigo, "'", "''") + " +1 "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()
Response.Redirect("show-vote.asp")
%>
报错:
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] UPDATE 语句的语法错误。
/vote/count.asp, 第 16 行(即是Command1.Execute())
请问错在什么地方,实在弄不明白,请各位能否指点以下
<%
set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_vote_STRING
Command1.CommandText = "UPDATE votedbvote SET " + Replace(Command1__kigo, "'", "''") + " = " + Replace(Command1__kigo, "'", "''") + " +1 "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()
Response.Redirect("show-vote.asp")
%>
报错:
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] UPDATE 语句的语法错误。
/vote/count.asp, 第 16 行(即是Command1.Execute())
请问错在什么地方,实在弄不明白,请各位能否指点以下