Is the field Date a DateTime field? If so, then the problem may be the value
you are putting in that field. Use CreateODBCDate as it appears you used for
DateModified.
The other problem now that I look closer is that you have Article in the
field list twice.
Chris
------------------------------------
Christopher P. Maher
Maher Associates, Inc.
Actuarial and Computer Consulting
[EMAIL PROTECTED]
http://www.maherassociates.com
> -----Original Message-----
> From: Seamus Campbell [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, January 07, 2001 5:54 PM
> To: CF-Talk
> Subject: insert query problems
>
>
> Hi
> I keep getting this error message, have racked my brains, doublechecked
> field names form names and table names but still haven't got a clue as to
> the problem.
>
> Can anyone help, please?
> Let me know if any more info is required
> Many thanks
> Seamus
>
>
>
>
> ODBC Error Code = 37000 (Syntax error or access violation)
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
> statement.
> SQL = "INSERT INTO tblNews ( OrgID, Date, Subject, Article, Article,
> DateModified)
> VALUES (2769, '8/1/2001', 'Heading', 'Article notes', 31, '{ts
> '2001-01-08
> 09:49:58'}')"
> Data Source = "BOOKBUSINESS_DATA"
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
