On Thu, 2007-12-13 at 10:24 +0100, Michael Lackhoff wrote: Hi Michael
> To make life easier I created a custom field type in RHTMLO that changes > '' to undef/NULL where necessary but I wonder if there isn't a better > way, like a RDBO parameter 'empty_sets_null' or 'false_sets_null' in a > column definition. Alternatively, consult: Joe Celko's SQL for Smarties 1-55860-576-2 Morgan Kaufmann 2000 (2nd Ed) p 120, where Joe says: It is a good idea to declare all your base tables with NOT NULL constraints on all columns whenever possible. Maybe that's pointing you to the real problem. -- Ron Savage [EMAIL PROTECTED] http://savage.net.au/index.html ------------------------------------------------------------------------- SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
