in reply to Formatting question??

my @row = $_read_sth->fetchall_arrayref
That should ring a bell - the method returns an arrayref, and you're assigning it to an array. Not to an array reference.

BTW if you need to process the data row by row, why don't you just read the data row by row from the db? That's far more efficient (especially in terms of memory)

while (my @row = $sth->fetchrow_array){ print join(", ", @row), "\n"; }

Replies are listed 'Best First'.
Re^2: Formatting question??
by grizzley (Chaplain) on Apr 15, 2008 at 10:21 UTC
    And it is fetchall_arrayref. Why is it in while loop? Doesn't it return all rows at once?