Re: Error when writing a sql statement into a field.

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

Re: Error when writing a sql statement into a field.

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

Error when writing a sql statement into a field.

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 field was being updataed with: query = "I

RE: Error when writing a sql statement into a field.

| 20010221110030 | +--+-------- ---- --------++ 52 rows in set (0.11 sec) Thanks for the very quick response. a.l. -Original Message- Fro