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:
[email protected]
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/
