Re: class-dbi-mysql and null values

I found a resolution. Its actually quite simple: just test for the length of the owner parameter and explicity asign undef if the length is 0.

if (length($owner) > 0) {
    $case->owner( $q->param('owner') );
} else {
    $case->owner( undef );
}
[download]

Thanks for you assistance,
davidj

Comment on Re: class-dbi-mysql and null values Download Code

Replies are listed 'Best First'.
Re^2: class-dbi-mysql and null values by davidrw (Prior) on Nov 05, 2006 at 13:19 UTC
Depending on your data (e.g. if it's ok to null out a 0), you could simply do: `$case->owner( $owner \|\| undef );` [download] This is great writeup on what counts as false: True or False? A Quick Reference Guide	[reply] [d/l]