为什么我一加上这个money就会出错
if   Rs( "IsTopic ")=1   then   Conn.execute( "update   [BBSXP_Threads]   set   money= ' "&money& " ',   Topic= ' "&Subject& " '   where   ID= "&Rs( "ThreadID ")& " ")

只要我把money= ' "&money& " '这个加上来就会出现以下错误，如何解决

Microsoft   JET   Database   Engine   错误   '80040e14 '  

UPDATE   语句的语法错误。  


------解决方案--------------------
money的字段类型是什么?

先把
sqlStr = "update [BBSXP_Threads] set money= ' "&money& " ', Topic= ' "&Subject& " ' where ID= "&Rs( "ThreadID ")& " "

Response.Write sqlStr

把结果拿出看看
------解决方案--------------------
set [money]= " & money & "