PM
To: 'MCMULLIN, NANCY'; dbi-users@perl.org
Subject: RE: Retrieve values from Oracle
MCMULLIN, NANCY [mailto:[EMAIL PROTECTED] wrote:
Here's the easiest question you've had all day ;-)
I'm attempting to retrieve values and pass them to another program. But
I'm only able to grab and save
Here's the easiest question you've had all day ;-)
I'm attempting to retrieve values and pass them to another program. But
I'm only able to grab and save the first value. What do I have wrong?
CODE snippet:
my $sth = $dbh-prepare(SELECT field1, field2 FROM table WHERE field1
= '$p1')
MCMULLIN, NANCY [mailto:[EMAIL PROTECTED] wrote:
Here's the easiest question you've had all day ;-)
I'm attempting to retrieve values and pass them to another program. But
I'm only able to grab and save the first value. What do I have wrong?
CODE snippet:
my $sth = $dbh-prepare(SELECT
From: MCMULLIN, NANCY [EMAIL PROTECTED]
Date: 2005/02/09 Wed PM 12:45:09 CST
If you're sure you're only getting back one row...
while (my $row = $sth-fetchrow_arrayref())
my ($field1,$field2)=$sth-fetchrow_array())
Otherwise,
while (my ($field1,$field2)=$sth-fetchrow_array())