Hi,
I am using fetchall_arrayref to fetch multiple rows from the SQL result
set after executing it. Then I was trying to see the values obtained,
but I get the following.
ARRAY(0x203dfe4c)
ARRAY(0x2085df00)
ARRAY(0x2085df24)
ARRAY(0x203dfe4c)
ARRAY(0x2085df00)
ARRAY(0x2085df24)
I was expecting to see the actual values and not array ref.
My code is below:
$array_ref = $pstmt1->fetchall_arrayref();
foreach $row (@$array_ref)
{
# ( $wc_cd, $sord_fnAA, $sord_fnDD ) = @$row;
print "$row\n";
}
$max_load_row_ct = $$array_ref[0];
$nbr_files_AA = $$array_ref[1];
$nbr_files_DD = $$array_ref[2];
print "$max_load_row_ct\n";
print "$nbr_files_AA\n";
print "$nbr_files_DD\n";
$pstmt1->finish;
I tried using @$array_ref[0] in the above assign statements. But nothing
worked, please help.
Thanx..
-Bheem
_______________________________________________
Perl-Unix-Users mailing list
Perl-Unix-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
