Re^2: My doubts about using fetchall

That is interesting, do you mean by "pass the function a list of columns you want" like this?



...
my $sql  = "select id, account_number, date
                from my_table where id <>''
                order by date desc";

my @columns = qw( id account_number box );

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

Comment on Re^2: My doubts about using fetchall_arrayref Download Code

Replies are listed 'Best First'.
Re^3: My doubts about using fetchall_arrayref by CountOrlok (Friar) on Apr 02, 2013 at 14:02 UTC
Yes. Though, to be nit-picky, in your example the third item in the list should be date, not box.	[reply]
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]
Re^5: My doubts about using fetchall_arrayref by CountOrlok (Friar) on Apr 02, 2013 at 14:58 UTC
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]
Re^5: My doubts about using fetchall_arrayref by CountOrlok (Friar) on Apr 02, 2013 at 14:51 UTC
can you show the code that is populating the template file?	[reply]