Hi:
If you want to check the values in arrayref using foreach, you write something
like this:
foreach $row (@{$arrayref}) {
etc...
To dereference $arrayref.
Bye.
>
>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
>
- Marcos Legido.
[EMAIL PROTECTED]
Programación de software y administración de sistemas.
_______________________________________________
Perl-Unix-Users mailing list
Perl-Unix-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
