Re: Correct way to deal with returned NULLs?

From: David N Murray (dmurray_at_jsbsystems.com)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 11:25:44 -0400 (EDT)
To: "Jesse, Rich" <Rich.Jesse@quadtechworld.com>

$dateclosed = '' if !defined($dateclosed);

On Apr 26, Jesse, Rich scribed:

> Howdy,
>
> I have a question from one of our developers that's been bugging me and I
> can't find an answer. Given this v1.37 DBI code fragement:
>
> while ( my ($projectno,$description,$dateclosed) = $sth->fetchrow_array )
> {
> print "$projectno";
> print "$description";
> print "$dateclosed";
> print "\n";
> }
>
> ...I keep getting a "Use of uninitialized value in string" message on the
> print of the $dateclosed variable, whenever the corresponding Oracle DB
> column is NULL. And you've already figured out that the program is run with
> "-W". When the "-W" is dropped, no message.
>
> This has got to be simple, but a read through the DBI FAQ, the index of
> Tim's book, and Google, and I'm still unable to provide a simple answer
> that's probably staring me in the face, other than "Drop the -W".
>
> How do others deal with this?
>
> TIA,
> Rich
>
> Rich Jesse System/Database Administrator
> rich.jesse@quadtechworld.com QuadTech, Sussex, WI USA
>

Relevant Pages