Dear JDBC, Although you may crash less, when connecting mySQL to Coldfusion, it has come to my attention that you cause some unexpected errors, which didn't seem to bother me much. I (ODBC) didn't mind datetime fields set to 00:00:00. If you try to run a CF query that returns a 00:00:00 date, you (JDBC) throw an exception. I (ODBC) also allow a user to update a date field to '' in Coldfusion. So [set datetimefield = ''] was ok. You (JDBC) throw an exception on that one too. Your old friend, ODBC. Share on Twitter Share on Facebook