Re: [RDBO] good way to handle empty fields?

2007-12-13 Thread Michael Lackhoff
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

Re: [RDBO] good way to handle empty fields?

2007-12-13 Thread Ron Savage
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 > colum

Re: [RDBO] Rose::DB array column bug

2007-12-13 Thread Derek Watson
That's ok, if you could just issue another release on CPAN just for this bug that would be great :P Thanks John! On 12/13/07, John Siracusa <[EMAIL PROTECTED]> wrote: > > On Dec 13, 2007 11:58 AM, Derek Watson <[EMAIL PROTECTED]> wrote: > > Is there a reason why I can't set the first value of an

Re: [RDBO] Rose::DB array column bug

2007-12-13 Thread John Siracusa
On Dec 13, 2007 11:58 AM, Derek Watson <[EMAIL PROTECTED]> wrote: > Is there a reason why I can't set the first value of an array to NULL? I > want to store this {NULL, 1, 2, 3} by way of an RDBO array column but I > think the following function from Rose::DB 0.737 is preventing me from doing > so:

[RDBO] Rose::DB array column bug

2007-12-13 Thread Derek Watson
Is there a reason why I can't set the first value of an array to NULL? I want to store this {NULL, 1, 2, 3} by way of an RDBO array column but I think the following function from Rose::DB 0.737 is preventing me from doing so: sub format_array { my($self) = shift; my @array = (ref $_[0]) ? @{$

[RDBO] ANNOUNCE: Rose::DB::Object 0.766 released

2007-12-13 Thread John Siracusa
This release has some important error detection bug fixes, plus the usual collection of minor new features, including the now-officially-named "undef_overrides_default" column attribute. A new version of Rose::DB is required, which itself contains some enhancements to aid database connection shari

Re: [RDBO] good way to handle empty fields?

2007-12-13 Thread John Siracusa
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 bu

[RDBO] good way to handle empty fields?

2007-12-13 Thread Michael Lackhoff
Hello, perhaps this is related to the new "undef_sets_null" but I am not sure. The problem: I have some fields where it is important if they are "empty" or not. Now "emptyness" is not so easy in SQL as we all know, it could be '' or 0 or NULL. When I create a record with such a field, it is usuall