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
