have you tried pasting the query into access (queries pane) and run it there? That should give you a better error....
saying that I haven't fully followed this thread... ----- Original Message ----- From: "Damien Gallagher" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 24, 2004 11:48 AM Subject: RE: [ cf-dev ] trying to update date field in Access > Sure is a weird one as I have the field set to Required = no, (there's no > option here for Allow Zero Length) > > > -----Original Message----- > From: Nick de Voil [mailto:[EMAIL PROTECTED] > Sent: 24 February 2004 10:59 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] trying to update date field in Access > > > Harvest = NULL > > or just leave it out as Matt said > > Nick > > ----- Original Message ----- > From: "Lovelock, Richard J" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, February 24, 2004 10:53 AM > Subject: RE: [ cf-dev ] trying to update date field in Access > > > > >> You need to set it to NULL > > > > as in " Harvest = '<NULL>' " ?? > > > > _______________________________________________________ > > * Regards, > > Richard Lovelock, > > Senior Application Analyst. > > Westminster City Council - Web Support > > Cap Gemini Ernst & Young > > Southbank > > 95 Wandsworth Road > > London > > SW8 2HG > > ( 0870 906 7482 > > > > _______________________________________________________ > > > > > > -----Original Message----- > > From: Nick de Voil [mailto:[EMAIL PROTECTED] > > Sent: 24 February 2004 10:51 > > To: [EMAIL PROTECTED] > > Subject: Re: [ cf-dev ] trying to update date field in Access > > > > > > You need to set it to NULL, or not set it at all. Setting it to an empty > > string is not the same thing. CFQUERYPARAM can help. > > > > Nick > > > > ----- Original Message ----- > > From: "Damien Gallagher" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, February 24, 2004 10:38 AM > > Subject: [ cf-dev ] trying to update date field in Access > > > > > > > Hi all, > > > > > > I'm having a problem with updating a simple date field in MS Access. > > > The problem lies where I try to pass an empty string and it comes up > with > > an > > > ODBC error even though the field is NOT required. > > > > > > The code is: > > > > > > <cfquery datasource="#dsn#"> > > > UPDATE VintageReport > > > SET Yields = #Form.Yields#, > > > Rainfall = #Form.Rainfall#, > > > Sunshine = #Form.Sunshine#, > > > Flowering = '#Form.Flowering#', > > > Veraison = '#Form.Veraison#', > > > Harvest = '#Form.Harvest#', > > > VintageReportOther = '#Form.VintageReportOther#' > > > WHERE Wine_ID = #Cookie.wineid# > > > </cfquery> > > > > > > The error output contains: > > > > > > Error Code: Error Executing Database Query. [Macromedia][SequeLink JDBC > > Driver] > > > [ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in > > UPDATE > > > statement > > > SQL UPDATE VintageReport SET Yields = 60, Rainfall = 2 , Sunshine = 100 > , > > > Flowering = '', Veraison = '', Harvest = '', VintageReportOther = 'none' > > WHERE > > > Wine_ID = 244 > > > DATASOURCE IWIN02 VENDORERRORCODE -3503 SQLSTATE 42000 > > > > > > - where Flowering, Veraison, and Harvest are the date fields > > > > > > Any ideas? > > > Thanks, > > > Damien > > > > > > > > > ---------------------------------------------- > > > This mail sent through http://www.ukonline.net > > > > > > -- > > > ** 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] > > > > > > ======================================================= > > This message contains information that may be privileged or confidential > and is the property of the Cap Gemini Ernst & Young Group. It is intended > only for the person to whom it is addressed. If you are not the intended > recipient, you are not authorised to read, print, retain, copy, disseminate, > distribute, or use this message or any part thereof. If you receive this > message in error, please notify the sender immediately and delete all copies > of this message. > > ======================================================= > > > > > > -- > > ** 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] > > > PLEASE NOTE: THE ABOVE MESSAGE WAS RECEIVED FROM THE INTERNET. > > On entering the GSi, this email was scanned for viruses by the Government > Secure Intranet (GSi) virus scanning service supplied exclusively by Energis in > partnership with MessageLabs. > > Please see http://www.gsi.gov.uk/main/notices/information/gsi-003-2002.pdf for > further details. > > In case of problems, please call your organisational IT helpdesk > > > ---------------------------------------------- > This mail sent through http://www.ukonline.net > > -- > ** 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]
