> --Howdy:
>
> --Sorry, I should have added more detail in
> --my reply. When I did the posted suggestion,
> --I only got one column, but if I ran the SQL
> --by hand, I got them all.
>
> --But in the example below, you list out the
> --variables and then get the entire row.
> --I thought I cou
--Howdy:
--Sorry, I should have added more detail in
--my reply. When I did the posted suggestion,
--I only got one column, but if I ran the SQL
--by hand, I got them all.
--But in the example below, you list out the
--variables and then get the entire row.
--I thought I could just pull in the
-
At 09:30 AM 08/27/2003, Johnson, Shaunn wrote:
--Thanks for the reply:
--I think I'm well on my way, but, I'm looking
--at the results and the 'Programming the PERL DBI'
--book and it says that selectrow_array returns the
--value of the first field.
--selectall_arrayref and selectcol_arrayref
--do
> --Thanks for the reply:
>
> --I think I'm well on my way, but, I'm looking
> --at the results and the 'Programming the PERL DBI'
> --book and it says that selectrow_array returns the
> --value of the first field.
It returns an array:
my ($one,$two,$three) = $dbh->selectrow_array("SELECT one,t
--Thanks for the reply:
--I think I'm well on my way, but, I'm looking
--at the results and the 'Programming the PERL DBI'
--book and it says that selectrow_array returns the
--value of the first field.
--selectall_arrayref and selectcol_arrayref
--doesn't seem to help.
--how can I return all o
> Howdy:
Howdy
>
> I have a script where I want to
>
> * connect to database
> * create a subroutine where it executes
> and returns the value of the SQL
> * pass that value to another area
> to check and IF statement
> * continue with program
>
> I am having problems trying to figure out
