请问这段sql statement有问题吗？

?ex.Message
"Syntax error in UPDATE statement."

"UPDATE account_profile SET CUSID = 'CUS1000002', Total = '458.00', Outstanding = '458.00', Ref_num = '408', Date = '5/11/2006', Description = 'DN 002' WHERE CPRID = 'CPR1000010'"


我确认我的field name没有写错。。 但为何update不到呢？

milktin

简单的说
数目字(DATA TYPE)无需引号
Total = 458.00






[size=-1]-----------------------------------------
[size=-1]牛奶罐
[size=-1]零点一度 [url]www.dot1degree.com[/url]
[size=-1]从零点开始，寻找你人生第一度的变化！
[size=-1]我的 IT 日记
[size=-1]大马房地产资料个人收集

[ 本帖最后由 milktin 于 14-5-2006 06:43 PM 编辑 ]

我试过了不可以。。。。 为何？

strSQL = "UPDATE credit_payment_record SET CUSID = '" + CUSID + "', Total = '" + Total + "', Outstanding = '" + Total + "', Ref_num = '" + Ref_num + "', Date = '" + payment_date + "', Description = '" + desc + "' WHERE CPRID = '" + CPRID + "'"

还是

strSQL = "UPDATE credit_payment_record SET CUSID = '" + CUSID + "', Total = " + Total + ", Outstanding = " + Total + ", Ref_num = '" + Ref_num + "', Date = '" + payment_date + "', Description = '" + desc + "' WHERE CPRID = '" + CPRID + "'"

行了。。 问题出在date 这个field name, 我改去 payment_date就okie了