Ignore my question :) Mr Onnis gave me a hand - it was because the datetime field was a new addition to an existing table with existing data and it didn't automatically give it self a proper NULL value.
Running this fixed it: UPDATE Comments SET StartDate = NULL, EndDate = NULL -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Silwedel Sent: Sunday, 5 February 2006 9:29 PM To: [email protected] Subject: [cfaussie] Re: SOT: MySQL null date field It's a datetime field btw - not a date field -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Silwedel Sent: Sunday, 5 February 2006 9:21 PM To: [email protected] Subject: [cfaussie] SOT: MySQL null date field I'm sure this is a common problem, I just can't track down a solution... I have a basic select statement from a MySQL database which includes a date field which has a default NULL value. MySQL sets '0000-00-00 00:00:00' as the default NULL value but ColdFusion gives me this error when the SELECT statement runs: "Cannot convert value '0000-00-00 00:00:00' from column 14 to TIMESTAMP" Can any one offer any advice on how to handle this problem? Cheers, Chris
