On Sun, Jan 10, 2010 at 1:29 AM, Chris Blackwell <[email protected]> wrote: > re the zero date times, there's a jdbc param I always use with mysql, > iirc it's zeroDateTime=convertToNull which will give you null (or > empty string in cf) instead of invalid dates. > check the mysql connector j docs to double check, it's right down the > the bottom of the list of misc params.
Yeah, this crops up with Railo as well. For some weird reason, Adobe ColdFusion seems to default this behavior "on" but it looks like it is not the standard default behavior of the MySQL driver so in Railo we surfaced it as an option in the Administrator for data sources. There's even been a request to default this "on" in Railo as well, for compatibility with Adobe ColdFusion. I'd be interested to hear what the OpenBD folks think about this behavior? -- Sean A Corfield -- (904) 302-SEAN Railo Technologies US -- http://getrailo.com/ An Architect's View -- http://corfield.org/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood
-- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon mailing list - http://groups.google.com/group/openbd?hl=en !! save a network - please trim replies before posting !!
