Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: $dbh->selectall_arrayref to simple @array

by chrestomanci (Priest)
on Sep 15, 2011 at 20:17 UTC ( #926229=note: print w/ replies, xml ) Need Help??


in reply to $dbh->selectall_arrayref to simple @array

I was puzzling over that today. The issue is that selectall_arra­yref gives you back a reference to an array of arrays, where each row from the query result is put into an array, and references to each of those arrays are put into a higher level array. A reference to that top level array is returned. All this is usefull if you are querying for several collums in each row, but is a useless level of indirection if you are only querying for one.

The solution I used was to make use of the map function to flatten the data structure. I hope it does not look to much like code golf!

my @query_results = map { $_->[0] } @{ $sth->fetchall_arrayref() };


Comment on Re: $dbh->selectall_arrayref to simple @array
Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (7)
As of 2014-07-25 09:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (170 votes), past polls