On 13.12.2007 14:03 John Siracusa wrote: > On Dec 13, 2007 4:24 AM, Michael Lackhoff <[EMAIL PROTECTED]> wrote: >> When I create a record with such a field, it is usually NULL but >> after some editing with the help of RHTMLO the empty field value could >> become '' when saved. > > I believe the latest release of Rose::HTML::Objects fixed this bug for > Numeric fields. That is, you should get undef for an empty Numeric > field instead of an empty string. Does this bug exist in other field > types as well?
I didn't install the latest version yet but this is what I get with a text field: 1. set a field 'anrede2' to NULL with the sqlite3 command line 2. edit the record with RHTMLO without touching 'anrede2' Here is the form/field definition: anrede2 => {type => 'text', class => 'normfield'}, linked to RDBO with init_with_object/object_from_form 3. After $obj->save I check again at the command line and it is '' But I wouldn't count this as a bug. After all there is no way for a query parameter to keep the difference between undef/NULL and ''. Both would look like http://myserver/myapp?anrede2=&otherparam=xyz and it is always arbitrary if RHTMLO makes it '' or undef. That's why I suggested a RDBO column attribute. Ron's suggestion to make it NOT NULL would also solve the problem but then I would have to prepopulate every optional field with '' -- a value that is not really meant to be a value but is meant to be empty/undef/NULL. I like it when the schema reflects my intention, so that NOT NULL really means "Don't leave this empty", this is why I don't like to use it for fields that are meant to be optional. But thanks for the reading suggestion, will try to read it, perhaps I get convinced. -Michael ------------------------------------------------------------------------- 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