zeroDateTimeBehavior=convertToNull add it to the jdbc url's query string part.
maybe entering it into the Connection String box (under Advanced Settings in the CF Administrator)'s Data Sources page) will work too, but i have not tried it. --- Azadi Saryev Sabai-dee.com http://www.sabai-dee.com Jim McAtee wrote: > Is there a way of dealing with MySQL default 0000-00-00 dates beyond going > through all of our databases and changing them to NULL or a valid date? > > I came across an aticle suggesting that there may be a JDBC connection > setting that will keep the MySQL JDBC driver from choking on them, but > there weren't instructions on how it's done. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297701 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4