Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re^3: Result set into array

by shenme (Priest)
on Nov 19, 2006 at 02:05 UTC ( [id://584911]=note: print w/replies, xml ) Need Help??


in reply to Re^2: Result set into array
in thread Result set into array

Guessing from reading the docs (!) but it looks like selectall_hashref() is executed using the DB handle, so your code might better be:
my $hash = $dbconn->selectall_hashref($sql_statement);
You may have been led astray by the talk of preparing a statement ahead of time, but even then you still use the DB handle.
my $sth = $dbconn->prepare($sql_statement); . . . . . . . my $hash = $dbconn->selectall_hashref($sth);
As for setting the valuable RaiseError flag, it looks like you'll have to do that on the DB handle when using selectall_hashref, perhaps something like:
{ local $dbconn->{RaiseError} = 1; my $hash = $dbconn->selectall_hashref($sql_statement); . . . . . . . }
Go back and read the DBI docs whenever something goes 'wrong' - sometimes it takes me a couple "read again"s before it sinks in to my flat file head.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others admiring the Monastery: (3)
As of 2024-03-29 06:20 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found