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 wandering the Monastery: (7)
As of 2015-07-08 04:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (94 votes), past polls