why not use a NVL in your select staetment?
Mitch Helle-Morrissey wrote:
> Is there any way to have DBI return NULL database values as something other
> than Perl undef? It's a pain if you're printing out a bunch of columns
> without examining the values because printing an undef generates warnings.
> I wrote my own function to map undefs to something else, but I was thinking
> it would be nice to have an attribute of how NULL database values will be
> returned to Perl. Maybe something like:
>
> $dbh->{NULL_VALUE} = '';
> $dbh->{NULL_VALUE} = 'NULL';
> $dbh->{NULL_VALUE} = undef; # current behavior
>
> Mitch
--
Morris Paterson, PhD [EMAIL PROTECTED]
Inpharmatica www.inpharmatica.co.uk
60 Charlotte Street
London W1T 2NU
Tel: +44 (0)20 7074 4690
Fax: +44 (0)20 7074 4700
