I am not completely sure what you want, but the following Template global might help:
Code:
sub {
#-------------------------------------------------------------------
# Get description field from table
# $table : table, $id: pk; $desc: description field
#
my ($table, $id, $desc) = @_;
($table and $id and $desc) or return;
my $tags = GT::Template->tags;
my $home = $tags->{home};
my $rs = $home->{sql}->table($table)->get($id,[$desc]);
return $rs->{$desc};
}
Call it with the table name, the id of the entry en the column name you need like this
Code:
<%show_description('Users',$userid,'fullname')%>
Is that what you need?
Jasper
BTW Why did you repost this entry in a new thread?
http://www.bookings.org