Just simple create a global template like:

sub {
my ($select_name, $cat_id) = @_;
my $tags = GT::Template->tags;

my $results = $DB->table('Product_Category')->select({ category_code => $cat_id }, ['product_code', 'product_name'])->fetchall_hashref;

my (@values, @names);
foreach (@$results) {
push @values, $_->{product_code};
push @names, $_->{product_name};
}

return $tags->{home}->{disp}->select ( {
name => $select_name,
values => \@values,
names => \@names,
value => $tags->{$select_name},
blank => 1,
});
}

Now you can use <%global_name('select_name', category_code)%> tag in template.

Hope that helps.

TheStone.

B.