#12002/8/13 17:31:57
做一个投票系统时,使用DSN连接,一点问题也没有。
可是换作OLEDB字符串连接时,其它所有的页面运行都正常,只有那个投票以后要在原来的count上加1的finish.asp页面运行出现错误:
Microsoft JET Database Engine 错误 '80040e14'
UPDATE 语句的语法错误。
/vote/finish.asp,行50
行50为:
<%
set cmdupdcount = Server.CreateObject("ADODB.Command")
cmdupdcount.ActiveConnection = MM_cnvote_STRING
cmdupdcount.CommandText = "UPDATE Item SET Count =Count+1 WHERE ItemID =" + Replace(cmdupdcount__stritem, "'", "''") + " "
cmdupdcount.CommandType = 1
cmdupdcount.CommandTimeout = 0
cmdupdcount.Prepared = true
cmdupdcount.Execute() '此为行50
%>
请各位大侠帮忙看一下问题所在,在下先行谢过!