I think that 0000-00-00 in your data model is trying to mean what
NULL can mean.
Can you tell us the semantics of 0000-00-00 and NULL as well as a
non-zero date in your data model?
On 9/30/05, John Siracusa <[EMAIL PROTECTED]> wrote:
> On 9/30/05, Uwe Voelker <[EMAIL PROTECTED]> wrote:
> > Given this schema:
> >
> > CREATE TABLE `DATUM` (
> > `ID` int(10) unsigned NOT NULL auto_increment,
> > `DATUM` datetime NOT NULL default '0000-00-00 00:00:00',
> > `DATUM2` date NOT NULL default '0000-00-00',
> > PRIMARY KEY (`ID`)
> > )
> >
> > I can not save a record without DATUM or DATUM2. See attached script.
> > The error message is "Column 'DATUM2' cannot be null".
> >
> > I know what you'll say: make the column 'NULL' and it works this way.
>
> 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.
>
> > But: When you load such an object you correctly map '0000-00-00' to
> > undef. Why can't it be the other way too? Saving 'undef' maps to
> > '0000-00-00'.
>
> Then what happens when someone actually wants to insert a NULL in a date
> column?
>
> -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
>
-------------------------------------------------------
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
