in reply to fetchall( )

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.

Replies are listed 'Best First'.
Re^2: fetchall( )
by maarten_m4 (Initiate) on Apr 21, 2005 at 11:38 UTC
    I'm new to perl, so can you tell me how to do that? Or give me a few lines of sample code?
[reply]
      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']);

      [download]
      -albert
[reply]
[d/l]

In Section Seekers of Perl Wisdom