Date is a reserved word in Access. I think there is some way around it (by
surrounding field names with [ or something but I am not sure). You can also
try prefixing date with tablename, it may accept that.
I think the better solution is to rename the field in the table so you don't
have the problem in the future.
HTH
----- Original Message -----
From: "Seamus Campbell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, January 07, 2001 3:54 PM
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
