--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 of the fields that
--was selected?
--Thanks again!
-X
[snip]
>>>
>>> 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 SQL is actually being processed
>>> and if so, why the value isn't being returned.
>>
>> do() returns 0E0 on error and number of rows affected as
>>provided by mysql.
>>I think you want selectrow_array()
>>
>> my($joe,$mama) = $dbh->selectrow_array('SELECT joe,mama FROM
>>joemama WHERE ID=83');
>>
>>
>>HTH
>>
>>DMuey
>>>
>>> [snip script]
>>
