Re: Zero dates "0000-00-00"
Re: Zero dates "0000-00-00"
- Subject: Re: Zero dates "0000-00-00"
- From: "Cheong Hee (Gmail-P)" <email@hidden>
- Date: Thu, 23 Apr 2009 18:02:08 +0800
Just wonder a dummy Q...
If the date column is not allow null, isn't it suppose to throw exception if
it is Zero Date (=null, not? ).
Or else it should be initialized to some value, e.g. current date?
Cheers
Cheong Hee
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