RE: Retrieve values from Oracle

2005-02-10 Thread De Simone, Andrew \(Genworth\)
M 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

Re: Retrieve values from Oracle

2005-02-09 Thread amonotod
> 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_arra

RE: Retrieve values from Oracle

2005-02-09 Thread Ronald J Kimball
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