Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re^4: DBI and arrays

by Anonymous Monk
on Jan 17, 2012 at 12:46 UTC ( [id://948312]=note: print w/replies, xml ) Need Help??


in reply to Re^3: DBI and arrays
in thread DBI and arrays

Just wanted to amend that, since you seem to be confused between the database handle functions and the statement handle functions, this would be the equivalent written using the sth functions:
$sth = $dbh->prepare($sql); $sth->execute('TESTA1', 'TESTA2', 'TESTA3'); $aref = $sth->fetchall_arrayref({stuff => here});
(the database handle functions offer the do() and select*() shortcuts for doing similar things, although they are not as efficient in some cases)

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others meditating upon the Monastery: (4)
As of 2024-03-29 02:38 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found