Re: class-dbi-mysql and null values

[davidj]

in reply to 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 );
}

Thanks for you assistance,
davidj

[davidrw]

Depending on your data (e.g. if it's ok to null out a 0), you could simply do:

$case->owner(  $owner || undef  );

This is great writeup on what counts as false: True or False? A Quick Reference Guide