Hi,
Try this global:
sub {
my ($rec) = @_;
my $id = $rec->{ID};
my $db = $DB->table ('Category','CatLinks');
my $sth = $db->select ( { 'CatLinks.LinkID' => $id }, ['Category.Full_Name'] );
my $output;
while (my $cat = $sth->fetchrow_array){
$output.= qq~<li>$cat~;
}
return $output;
}
I'm assuming that the id of the link is available as a tag in the template.
Hope it works,
Laura.
Edit: I just added a fix for multiple categories.
The UK High Street
Try this global:
sub {
my ($rec) = @_;
my $id = $rec->{ID};
my $db = $DB->table ('Category','CatLinks');
my $sth = $db->select ( { 'CatLinks.LinkID' => $id }, ['Category.Full_Name'] );
my $output;
while (my $cat = $sth->fetchrow_array){
$output.= qq~<li>$cat~;
}
return $output;
}
I'm assuming that the id of the link is available as a tag in the template.
Hope it works,
Laura.
Edit: I just added a fix for multiple categories.
The UK High Street