Re: Zero dates "0000-00-00"
Re: Zero dates "0000-00-00"
- Subject: Re: Zero dates "0000-00-00"
- From: Katya Yurukova <email@hidden>
- Date: Thu, 23 Apr 2009 15:28:29 +0300
Thanks for the prompt responses.
I couldn't get the custom data type approach to work, but setting ?
zeroDateTimeBehavior=round did the trick for me, as it converts the
rounded value back to zero date when the object is saved to the
database.
Cheers,
Katya
On Apr 23, 2009, at 5:16 AM, Lachlan Deck wrote:
On 23/04/2009, at 9:54 AM, Andrew Lindesay wrote:
I've stumbled on a problem related to this issue. The database is
MySQL again and the zero dates are widely used there. What causes
my problem is that when an EO is fetched and it had a zero date
set for some column, the corresponding property is set to null, so
when I edit and try to save the modified object I get an exception
because the column that contained the zero date does not allow
null. Do you know if there is some work around for this ?
Perhaps a good way forward with this is to use a custom data type
which could handle these awkward situations by converting to and
from the "right" types.
That sounds like the easiest way to go.
with regards,
--
Lachlan Deck
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden