Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re^7: My doubts about using fetchall_arrayref

by CountOrlok (Friar)
on Apr 02, 2013 at 16:13 UTC ( #1026730=note: print w/ replies, xml ) Need Help??


in reply to Re^6: My doubts about using fetchall_arrayref
in thread My doubts about using fetchall_arrayref

If you have a more advanced query like this one:

my $sql = "select id, account_number, CONVERT(VARCHAR(10),date,101) as + date from my_table where id <> '' order by date desc";
Then you can call the version of _all_data() that I gave above as either:
my @columns = qw( id account_number date ); my $results = $self->_all_data($sql, \@columns);
or
my $results = $self->_all_data($sql);
They will both get the same result set.


Comment on Re^7: My doubts about using fetchall_arrayref
Select or Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (15)
As of 2015-07-31 12:58 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 (277 votes), past polls