christopherbarsuk has asked for the wisdom of the Perl Monks concerning the following question:

I'm using DBI with a MySQL database, and, reading through the documentation, I see the method 'selectcol_arrayref' -- when I try this method, it always returns 'undef'.

Q1: Is this method actually available?

Q2: Is there a way to determine what module is supplying an inherited method? That is, if I want to look at the code for this method, how do I determine where from it's being inherited?

Muchas thanks for any insight...

  • Comment on selectcol_arrayref not working/available?

Replies are listed 'Best First'.
Re: selectcol_arrayref not working/available?
by tadman (Prior) on Aug 10, 2001 at 05:42 UTC
    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.
[reply]
[d/l]
[select]

Back to Seekers of Perl Wisdom