Ahh, yes, I should have caught that last night. You have two options:
1) Set die_on_bad_params to false
2) Change your query to select only the fields you want in the template
my $last_five = q~SELECT imdbID, title
FROM videodata
WHERE Mediatype <> '50'
ORDER BY created DESC LIMIT 5~;
I almost always go with option 1 so that neither myself nor the designers I may be working with have to muck with my Perl or SQL code to make simple modifications to the templates.
~Charlie
1) Set die_on_bad_params to false
Code:
my $t = HTML::Template->new(filename => 'sig.tmpl', die_on_bad_params => 0);2) Change your query to select only the fields you want in the template
Code:
# Query 1 to get desired records for your loop my $last_five = q~SELECT imdbID, title
FROM videodata
WHERE Mediatype <> '50'
ORDER BY created DESC LIMIT 5~;
I almost always go with option 1 so that neither myself nor the designers I may be working with have to muck with my Perl or SQL code to make simple modifications to the templates.
~Charlie