Beefy Boxes and Bandwidth Generously Provided by pair Networks
Come for the quick hacks, stay for the epiphanies.
 
PerlMonks  

Re: DBI and HTML::Template

by lachoy (Parson)
on Nov 22, 2001 at 09:30 UTC ( [id://126942]=note: print w/replies, xml ) Need Help??


in reply to DBI and HTML::Template

With more recent versions of DBI, you can do:

my $sth = $dbh->prepare( $sql ); # Fetch rows as arrayrefs my $rows_as_arrayrefs = $sth->fetchall_arrayref; # OR fetch all rows as hashrefs my $rows_as_hashrefs = $sth->fetchall_arrayref( {} );

Both invocations return an arrayref, but the first returns an arrayref of arrayrefs, the second an arrayref of hashrefs.

Chris
M-x auto-bs-mode

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://126942]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others sharing their wisdom with the Monastery: (3)
As of 2025-07-11 20:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.