in reply to push(@ary,\%hash)
$row will be a reference to an array of arrayrefs. E.g. ...my $row = $dbh->selectall_arrayref(...)
... is the first column of the first row of output. If you want an array of hashrefs, use selectall_hashref():$row->[0]->[0]
$row->[0]->{'g_afsluttet'} is the column named 'g_afsluttet' in the first row of output. Now, if I understand your question right, you want to modify one of the columns of your output. You want to replace the value of the column named 'g_afsluttet' with con_date(<value>) for every row in the output? If that's the case, you can do it like this:my $row = $dhb->selectall_hashref(...)
my $rows = $dbh->selectall_hashref(...); ... foreach my $hashref (@$rows) { $hashref->{'g_afsluttet'} = con_date($hashref->{'g_afsluttet'}); } ... $tmpl->param(LOOP => $rows);
-Matt
|
|---|