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]
