Quoting Denesa K Shaw <[EMAIL PROTECTED]>:
> How does a script handle when null values are returned from a stored
> procedure?
The same as any other NULL values.
http://search.cpan.org/~timb/DBI/DBI.pm#Notation_and_Conventions
But you are asking the wrong question. You want to know when the st
How are you checking for NULL?
I normally use:
if (!defined $var)
http://www.orafaq.com/faqperl.htm#DBDNULL
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Denesa K Shaw [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 09, 2005 7:24 AM
To: dbi-users@p
On Fri, May 07, 2004 at 10:04:20AM +0200, [EMAIL PROTECTED] wrote:
>
> I see your point that you need to identify all the possibilities and
> pre-prepared them, but here you only prepare what you need, and then of
> course, only once. All you need to do is work out a naming convention so
> that
<[EMAIL PROTECTED]>, "GOMEZ, CYNTHIA M
(CYNTHIA)&quo
; Bretz, Ellen; GOMEZ, CYNTHIA M (CYNTHIA);
Paul Weinstein; TOMAS, ROGER (ROGER)
Subject: RE: null values
RE preparing muliple times:
You could do the following (unless $sth) :
my $sth; # <- must be outside the for loop
for (my $i = 0; $i <= $#columns; $i++)
{
$sql .= "
ot;GOMEZ,
CYNTHIA M (CYNTHIA)" <[EMAIL PROTECTED]>
Sub
I posted this solution originally.
Please be aware that this solution does require a "prepare" for each execute. So if
you are running this logic in a loop many times, the run time will be more expensive
than other methods that were posted. You can monitor the performance of your app and
see i
Ellen
Cc: [EMAIL PROTECTED]
Subject: Re: null values
Bretz, Ellen wrote:
>
>
>
>
>I have a prepare statement for a select using DBI In ORACLE.
>
>
>
>One of the attributes can be null or can contain data. How do I set
up
>my scalar for the
>
>execute?
>
Use the NVL() and DECODE() functions. There was a thread on this last week.
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-Original Message-
From: Bretz, Ellen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 05, 2004 6:09 AM
To: [EMAIL PROTECTED]
Subject: null values
5/2004 08:11 AM
Please respond to ctantalo
To: "Bretz Ellen" <[EMAIL PROTECTED]>
cc: [EMAIL PROTECTED]
Subject:Re: null values
Bretz, Ellen wrote:
>
>
>
>
>I have a prepare statement for a select using DBI In ORACLE.
>
>
Bretz, Ellen wrote:
I have a prepare statement for a select using DBI In ORACLE.
One of the attributes can be null or can contain data. How do I set up
my scalar for the
execute?
I tried $scalar = 'NULL';
if it was null but didn't work.
Thanks
I just ran into this problem last wee
11 matches
Mail list logo
