Hello Terrence,
I think that 0000-00-00 in your data model is trying to mean what NULL can mean.
Yes.
Can you tell us the semantics of 0000-00-00 and NULL as well as a non-zero date in your data model?
The thing is: If a column is defined NOT NULL, MySQL has "default" default value. For date columns this is '0000-00-00'. Quite a few apps out there (and I too) use NOT NULL date columns. So the default becomes '0000-00-00', which is of course no valid date. But MySQL (at least older versions) don't care about valid or invalid dates, you could also store '2005-02-30'.
Now, RDBO maps '0000-00-00' to 'undef' which is exactly what it would be if the column was 'NULL'. The load() was already right, but save() failed.
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
