:oP all done and dusted now....despite my lack of brain today. D
-----Original Message----- From: Peter Harrison [mailto:[EMAIL PROTECTED]] Sent: 20 December 2002 14:14 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] CFQUERY and ACCESS Remember to test the forms by typing in characters such as: ' and | into the form fields. :) -----Original Message----- From: Garry Mills [mailto:[EMAIL PROTECTED]] Sent: 20 December 2002 11:41 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] CFQUERY and ACCESS Oh aye, course it is. Got a list pinned to my noticeboard and couldn't be arsed to stretch my head up to the top page! G -----Original Message----- From: Douglas Humphris [mailto:[EMAIL PROTECTED]] Sent: 20 December 2002 11:37 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] CFQUERY and ACCESS That's the one, FROM field too. D -----Original Message----- From: Garry Mills [mailto:[EMAIL PROTECTED]] Sent: 20 December 2002 11:34 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] CFQUERY and ACCESS 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] -- ** 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] -- ** 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]
