try renaming the 'to' field, it's a reserved word Garry
-----Original Message----- From: Douglas Humphris [mailto:[EMAIL PROTECTED]] Sent: 20 December 2002 11:16 To: [EMAIL PROTECTED] Subject: [ cf-dev ] CFQUERY and ACCESS Ok, I'm really stuck here and have been battling with Access all morning trying to get a simple INSERT statement to run. The error doesn't give much away... -- test.cfm -- <cfquery datasource="#senditDS#"> INSERT INTO tblECards (From,To,Message,PicID,QuoteID) VALUES ('[EMAIL PROTECTED]','[EMAIL PROTECTED]','test test 123 123',12,34) </cfquery> -- Browser output -- Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:33). ------------------------ I have double checked the database and there is a table called tblECards, and there are fields called: CardID (Autonumber), >From (Text 50), To (Text 50), Message (Text 255), PicID (Number, Default 0) QuoteID (Number, Default 0) And it's an Access 2000 db running on CF5, the datasource is set up correctly. I've tried restarting CFserver. Please help! I can't understand, I've been doing this kind of thing for three years, but I still can't do a simple INSERT into an Access table!! Douglas -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
