http://www.perlmonks.org?node_id=582308


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