Is the date field in the access database a date type. If so you will beed to use the createodbcdate() around the form.date.
Brian Knott -----Original Message----- From: Seona Bellamy [mailto:[EMAIL PROTECTED] Sent: Tuesday, 16 December 2003 8:09 AM To: CFAussie Mailing List Subject: [cfaussie] Why won't this query work? Hi guys, This one is driving me nuts. I have two queries. This one works just fine: <cfquery datasource="#session.dsn#"> INSERT INTO User (CharacterName, RealName, Password, Status) VALUES ('#FORM.CharacterName#','#FORM.RealName#','#password#','#FORM.Status#') </cfquery> This one, on the other hand, doesn't: <cfquery datasource="#session.dsn#"> INSERT INTO News (Headline, Body, Date, PostedBy) VALUES ('#FORM.Headline#','#FORM.NewsBody#','#FORM.Date#','#session.CharName#') </cfquery> This is the error I get when I try to run the first one: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. SQL = "INSERT INTO News (Headline, Body, Date, PostedBy) VALUES ('Test','test test','12/16/2003','Webmistress')" Data Source = "FBGALAN" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:2) to (2:37). The error occurred while processing an element with a general identifier of (CFRETHROW), occupying document position (246:11) to (246:21). Date/Time: 12/16/03 09:07:38 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 192.168.0.2 Query String: fuseaction=GM.SaveNews I've checked that the fieldnames are spelled right (as is the table name). I have even changed the date field to just "text" rather than "date/time" on the basis that it might have been the date formatting that was messing things up, but it still won't work. :( Can someone please help me figure out what's going wrong? Cheers, Seona. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.550 / Virus Database: 342 - Release Date: 9/12/2003 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
