Yes, it can be done by using the global template below:
sub {
my $tab = $DB->table('table_name');
$tab->select_options('GROUP BY category', 'ORDER BY category');
return { categories => $tab->select()->fetchall_hashref };
}
HTML code:
<%global_name%>
<select name="...">
<%loop categories%>
<option value="<%category%>"><%category%></option>
<%endloop%>
</select>
Hope that helps.
TheStone.
B.
sub {
my $tab = $DB->table('table_name');
$tab->select_options('GROUP BY category', 'ORDER BY category');
return { categories => $tab->select()->fetchall_hashref };
}
HTML code:
<%global_name%>
<select name="...">
<%loop categories%>
<option value="<%category%>"><%category%></option>
<%endloop%>
</select>
Hope that helps.
TheStone.
B.