Re: Correct way to deal with returned NULLs?

[Chuck Fox]

Jesse,

I normally use print ( defined( $var ) ? $var : "NULL" )

Your Friendly Neighborhood DBA,

Chuck

[EMAIL PROTECTED] wrote:

 

-----Original Message-----
From: Jesse, Rich [mailto:[EMAIL PROTECTED]
Sent: Monday, April 26, 2004 10:12 AM
To: '[EMAIL PROTECTED]'
Subject: Correct way to deal with returned NULLs?
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
[EMAIL PROTECTED]      QuadTech, Sussex, WI USA