Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Answer: selectcol_arrayref not working/available?

by tadman (Prior)
on Aug 10, 2001 at 05:42 UTC ( #103736=categorized answer: print w/replies, xml ) Need Help??

Q&A > database programming > selectcol_arrayref not working/available? - Answer contributed by tadman

I use selectcol_arrayref all the time, and it works very well. Make sure you are checking the value of your $dbh->err, and $dbh->errstr because there may be an error in your query.

The difference between selectcol_arrayref and selectall_arrayref is that the former returns a single array of all values in that column, while the latter returns an array of arrays of each row (AoA), even if each row contains only one entry. This is why the former is preferable for these kinds of circumstances.

Log In?
Username:
Password:

What's my password?
Create A New User
Chatterbox?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (3)
As of 2016-12-04 11:09 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    On a regular basis, I'm most likely to spy upon:













    Results (64 votes). Check out past polls.