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

Yes. Though, to be nit-picky, in your example the third item in the list should be date, not box.
  • Comment on Re^3: My doubts about using fetchall_arrayref

Replies are listed 'Best First'.
Re^4: My doubts about using fetchall_arrayref
by hdb (Monsignor) on Apr 02, 2013 at 14:10 UTC

    As there is redundant information in the sql statement and the list of columns, you could also do 

    ...
my @columns = qw( id account_number date );

my $sql  = "select ".join( ",", @columns).
                " from my_table where id <>''
                order by date desc";

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

    [download]
[reply]
[d/l]
      hdb: see my post below about "the_date". It could be that the query is going to do some reformatting of the columns (convert, concatenation, etc) and so trying to join the @columns into the $sql may not be a good idea.
[reply]
Re^4: My doubts about using fetchall_arrayref
by Anonymous Monk on Apr 02, 2013 at 14:12 UTC
    Yes, my fault, but doing that whay I am getting an error now with HTML::Template: 
    There has been an error: HTML::Template::param() : attempt to set para
+meter 'results' with a scalar - parameter is not a TMPL_VAR!<br>
Any idea why?

    [download]
[reply]
[d/l]
      can you show the code that is populating the template file?
[reply]

In Section Seekers of Perl Wisdom