Question

(asp)UPDATE 语句的语法错误。

错误提示为：
错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] UPDATE 语句的语法错误。
/Ken/xh_borrow2.asp, 第 51 行

我要做的是借书功能

错误代码是:
Set rs=db.execute("update xhbook set jieyueshu=jieyueshu+1,yijie=yijie+1,logid="&logid&" where id="&bookid&" ")

详细的代码我可以发个帮我的人

Answer 1

Set rs=db.execute("update xhbook set jieyueshu=jieyueshu+1,yijie=yijie+1,logid="&logid&" where id="&bookid&" ")
改成
db.execute("update xhbook set jieyueshu=jieyueshu+1,yijie=yijie+1,logid="&logid&" where id="&bookid&" ")

Answer 2

刚刚已经在群里给你回答了.

Set rs=db.execute("update xhbook set jieyueshu=jieyueshu+1,yijie=yijie+1,logid="&logid&" where id="&bookid&" ")
改成

Set rs=db.execute("update xhbook set jieyueshu=jieyueshu+1,yijie=yijie+1,logid="&logid&" where id="&bookid)

因为你后面多了" "

你或者改成这样也行
Set rs=db.execute("update xhbook set jieyueshu=jieyueshu+1,yijie=yijie+1,logid="&logid&" where id="&bookid&"")
但是没意义