Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
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 perusing the Monastery: (5)
As of 2024-04-14 18:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found