Re: records returned by DBI::selectall_hashref() are not ordered

[Eric Frazier]

try selectall_arrayref :)

At 10:50 PM 5/26/2005, Yu Wang wrote:

Example: (Using DBD::SQLite)

$ref_rsch = $dbh->selectall_hashref('
        SELECT * FROM rsch ORDER BY Idx
    ', 'Idx');

while (my ($k, $v) = each(%$ref_rsch)){
        while (my ($k, $v) = each(%$v)){
                print "$k => $v\n";
        }
}



Any ideas and suggestions?

Thanks,

Yu