Michael Sumner
Thu, 18 Oct 2007 14:43:26 -0700
I am moving from MySQL 4.1 to 5.0 and CF 7.02 to 8
Was pretty easy so far but I a table with a date column that are 0000-00-00.
When I try to query those fields I get this error
Error Executing Database Query.
Value '0000-00-00' can not be represented as java.sql.Date
I first thought it was the MySQL because I had install this one with Strict
Mode = true. It still may be but I have tried turning it off and I still
get this error. I take the query results to complete a CFREPORT. Any
chance it is the MySQL driver that is in 8. I think I used just the ODBC
driver in the current server. Isn't the MySQL driver a JDBC not a ODBC that
ships with 8?
I would appreciate any suggestions.
Michael Sumner
Nations Best Sports
817-788-0034 ext 244
817-788-8542 fax
_______________________________________________ Reply to DFWCFUG: List@list.dfwcfug.org Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/ www.teksystems.com/