Hi Stephen....already done that. The problem, I think, was that the delete date field was spazzing out when it was empty, causing the error. I'm putting a default date in there now, if none is entered, and it seems to work fine.
Cheers Will -----Original Message----- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 21 February 2002 12:42 To: CF-Talk Subject: Re: query problem Will, Your date needs to be an ODBC Date. Use CreateODBCDate() on your Date form field and CreateODBCTime() on your Time form Field. Regards Stephen ----- Original Message ----- From: "Will Swain" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 21, 2002 11:29 AM 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. > > ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
