Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

Re: class-dbi-mysql and null values

by davidj (Priest)
on Nov 05, 2006 at 12:04 UTC ( #582308=note: print w/replies, xml ) Need Help??

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,

Replies are listed 'Best First'.
Re^2: class-dbi-mysql and null values
by davidrw (Prior) on Nov 05, 2006 at 13:19 UTC

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://582308]
[Corion]: perldigious: That seems to be more the export and likely it's the recipients of that export that like the titles changes
[Corion]: ... "changed"
[Corion]: I usually expect fixed header names, but am sometimes lenient in the order of columns. But changing the report titles often sounds to me as if you are not the sole consument of the export ;)
[shmem]: perldigious: as always - if it ain't broke, don't fix it. Ther must be a very compelling reason for changing column names in a database. Those are rare.
[Corion]: If you have whitespace in the column names in the database, whap the DBAs ;)

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (9)
As of 2017-05-25 13:35 GMT
Find Nodes?
    Voting Booth?