Hi ,
notice your last field in the Values section.
'query += "\"" + this.customerId + "\",";'
get rid of the comma at the end. end replace it with a close'n
bracket.
notice the last field, you have one extra field in the values bracket.
'xxx","ccc
On Wed, 21 Feb 2001, allen2k wrote:
>
> Statement:
> Syntax error or access violation: You have an error in your SQL syntax near
> 'xxx","c","-1","-1",")' at line 1
>
>
> Was updating a log table in the database that has a message field. The message fie
| 20010221110030 |
+--+------------
----
--------++
52 rows in set (0.11 sec)
Thanks for the very quick response.
a.l.
-Original Message-
Fro
