Template Stuff

[bar10der]

I have an html form which has 60+ fields. To give a brief overview basically I am asking users to provide monthly status of accounts that they manage. I thought it will be good idea to populate form with data from previous month as value for many fields may not change every month. Data is stored in oracle table and I am able to extract data from oracle table. No problem here.br I have my html form and this is how I am loading form after getting data from oracle table (stored in @data)-

my $template   = $self->load_tmpl('acc.html');
$template->param($errs) if ref $errs; ##Validate input
$template->param(    
MONTH     => $monthName,        
YEAR     => $whichYear,
ACC     => $acName,
LEFT     => $lstring,    
f0       => $data[0],
f1      => $data[1],    
...
...    
f..n      => $data[..n],
 );

return $template->output;

Above is working fine but in case a new field is added or discarded, I have to change my script and I want to avoid this. HTML form field names are same as in oracle table's column name and I can extract fieldname and corresponding value from the tables and all that I want to know - is there a better way for assigning values to the form fields? Any help will be greatly appreciated.

[matija]

The param method returns the names of the fields in the template (if called without parameters):

$oracle_row=$sth->fetchrow_hashref;
foreach ($template->param) {
   param($_=>$oracle_row{$_});
}
return $template->output;

[BUU]

If I undestand you (and with some handwaving), this should work:

#furiously waving hand!
my %fields = get_fields(); # field name => old value

my @fields;
for(keys %fields )
{
  push @fields, { fname => $_, fvalue => $fields{$_} };
}

my $tmpl = HTML::Template->new();
$tmpl->params( old_fields => \@fields );
print $tmpl->output;

Then in your template code:

<tmpl_loop name='old_fields'>
  <input type='text' name='<tmpl_var fname>' value='<tmpl_var fvalue>'
</tmpl_loop>

You probably want to use escape=html in the tmpl tags, but i've omitted them for the sake of brevity.

[neniro]

Always use an AoH for this. You can get your result as hash from DBI and push it into an array. Use a loop in your templates to fill your table. Of course you still have to change your templates but you don't have to maintain your code if you make changes to your database.