Hello John,
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.
update() - Invalid default date: '0000-00-00' I would appreciate it if this works. Maybe only default => '0000-00-00'.
Then what happens when someone actually wants to insert a NULL in a date column?
If the column is NOT NULL it inserts '0000-00-00' (or the default date). As you know MySQL has a "default" default of '0000-00-00' for date columns which can't be deleted.
Bye, Uwe ------------------------------------------------------- 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
