I know, but my question was in regards of this situation:
How would I pass " CONVERT(VARCHAR(10),date,101)" to the names of columns.
From this code:
...
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);
...
To this:
...
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);
...
|