Hi,
if you want to use another table as far as I know you have to create a new .def file for your table and then you can create a global like:
my $results;
my $sth = $db->select ( { Name => "query" }, ['value']);
my $list = $sth->fetchall_hashref;
foreach my $value (@$list) {
$results .= "$valu\n";
}
return $results;
Regards
Niko
if you want to use another table as far as I know you have to create a new .def file for your table and then you can create a global like:
Code:
my $results;
my $sth = $db->select ( { Name => "query" }, ['value']);
my $list = $sth->fetchall_hashref;
foreach my $value (@$list) {
$results .= "$valu\n";
}
return $results;
Regards
Niko