Re^6: My doubts about using fetchall_arrayref

[Anonymous Monk]

In this case I will use the sample below for SQL queries that require a more complex call, yes I could use this:

my $rs = $sth->fetchall_arrayref({});

...
my $sql  = "select id, account_number, CONVERT(VARCHAR(10),date,101) a
+s date
                from my_table where id <>''
                order by date desc";

my @columns = qw( id account_number box );

my $results = $self->_all_data($sql, \@columns);
...

[CountOrlok]

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.