many thanks for all those every quick replies.
I had mistyped the "article" in twice so that wasn't the query problem
But it appeared that using Date was the culprit
Again thanks to everyone
Seamus
At 09:54 AM 8/01/01 , you wrote:
>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
