Yeah I have an idea... access is an arse make sure required is set to no, and allow zero length is set to yes within the table def.
Other than that I can't help you:) ----- 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]
