Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: DBI and HTML::Template

by lachoy (Parson)
on Nov 22, 2001 at 09:30 UTC ( #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? | Other CB clients
Other Users?
Others studying the Monastery: (3)
As of 2022-08-09 03:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?