It's ok, I have figured this out....... I am ODBC ing the dates and inserting a default one if a delete date is not added. The error seemed to be caused from their being no date entered in the delete date field.
Cheers Will -----Original Message----- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 21 February 2002 11:39 To: CF-Community Subject: query problem Hi all, Ok, having an annoying little problem, and I'm sure that it's something really obvious that I should know, but I guess I have just looked at it for too long..... This is my query: <cfquery name="addevent" datasource="#Request.App.dsn#"> INSERT INTO tbl_events(name, borough, full_address, event_date, event_time, description, delete_date, authorised) VALUES ('#Form.name#', #Form.borough#, '#Form.full_address#', #Form.event_date#, '#Form.event_time#', '#Form.description#', #Form.delete_date#, '#Form.authorised#') </cfquery> The field borough is a number type and the two date fields are date types. This is the error: Error Code: -3502 SQL State: 37000 Detail: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. SQL = "INSERT INTO tbl_events(name, borough, full_address, event_date, event_time, description, delete_date, authorised) VALUES ('fdhdfh', 1, 'sdfhsdfh', 12/08/02, '', 'asfasf', , 'yes')" Any ideas? Will ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
