Kevin
Thu, 18 Oct 2007 14:49:15 -0700
You can't have that. You have to either make the fields 'null' or add a script at the end of your connection string to ignore that restriction. I'm sure someone can provide that script as I don't have it at the moment.
-------------------------------------------------------- Kevin Fricke Lone Star Media [EMAIL PROTECTED] Office: (512) 371-1822 Mobile: (512) 626-0528 Fax: (512) 597-0909 Toll Free: (877) 791-7083 http://www.lonestarmedia.com From: [EMAIL PROTECTED] [EMAIL PROTECTED] On Behalf Of Michael Sumner Sent: Thursday, October 18, 2007 4:31 PM To: 'Dallas/Fort Worth ColdFusion User Group Mailing List' Subject: [DFW CFUG] Date Problems 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/