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]
