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
