Which month is the zero'th month? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/
2009/12/21 Stefan Richter <ste...@flashcomguru.com>: > > Some of you may have encountered the following error with date/time fields in > MySQL: > Error Executing Database Query. > > Cannot convert value '0000-00-00 00:00:00' from column 7 to TIMESTAMP. > > > This is usually resolved by adding the following to the advanced Datasource > settings under 'Connection String' in CF Admin: > noDatetimeStringSync=true&zeroDateTimeBehavior=convertToNull > > > My questions is: does anyone have a more elegant solution to this? Is there a > way to avoid this error without having to remember to edit new datasources > first? And should this error even be thrown - after all the value is not an > invalid date/time value so why does CF have issues with it? > > Cheers > > Stefan > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329287 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
