All working now....the delete date field was having a problem when no data was being added.
Cheers Will -----Original Message----- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 21 February 2002 11:30 To: CF-Talk 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 Swain Tecnical Director Hot Horse Ltd e: [EMAIL PROTECTED] t: 01273 675375 This email is intended for the recipient only and contains confidential information, some or all of which may be legally privileged. If you are not the intended recipient, you must not use, save, disclose, distribute, copy, print or rely on this email or any information contained within it. Please notify the sender by return and delete it from your computer. Thank you. ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists