On 10/1/05 3:19 AM, Uwe Voelker wrote:
>> Yeah, that's one option. Have you tried defining the column like this?
>>
>> DATUM2 => { type => 'date', not_null => 1, default => '0000-00-00' }
>>
>> If that doesn't work, I'll probably try to make it work.
>
> Unfortunately this doesn't work. RDBO complains, that '0000-00-00' is no
> valid date (and right it is). Perhaps the special threatment of
> '0000-00-00' for loading (mapping to 'undef') needs to be done in
> reverse for saving.
Yeah, I'll probably add it as a "keyword" for MySQL date columns. That way
it will pass through without complaint.
> I would prefer if your solution doesn't have to use "not_null => 1", but
> I leave it up to you.
You won't have to, but you will have to do at least this:
DATUM2 => { type => 'date', default => '0000-00-00' },
which accurately reflects the actual situation, IMO.
-John
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Rose-db-object mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/rose-db-object