Re: fetchall( )

[pearlie]

Hello, You need to store the data retrieved in an array of arrays, where each array in the bigger array represents a row. After retrieving each row, push it into the bigger array. Then you can use Data::Dumper module to display the data later.

[maarten_m4]

I'm new to perl, so can you tell me how to do that? Or give me a few lines of sample code?

[albert]

The Data::Dumper module is a great way to see what your data structure is like. To print the entire array structure:

use Data::Dumper;

my $ref = $sth->fetchall_arrayref();

print Data::Dumper->Dump([$ref], ['*ref']);

-albert