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
if the
--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
--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
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
--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
--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