Hi,
I fixed in your server, this problem happens when you don't have a correct foreign key for your tables, the fk should be defined like this structure (in your def files):
'fk' => {
'remote_table' => {
'this_column' => 'remote_column'
},
and below is the code;
my $tags = shift;
my $id = $tags->{Category_ID};
my $table = $DB->table('catalog', 'catalog_sub_category');
$table->select_options ('ORDER BY Sub_Category');
my $sth = $table->select ([\"DISTINCT catalog.Sub_Category_ID", 'Sub_Category'],{ Category_ID => $id });
my $output;
my $num;
while (my $row = $sth->fetchrow_hashref) {
$num = $num + 1;
($output .= "<font face=\"verdana,arial,helvetica\" size=\"-2\" color=red>$num.</font> <font face=\"verdana,arial,helvetica\" size=\"-2\"><a href=db.cgi?&sid=$tags->{session_id}>$row->{Sub_Category}</a></font><br><br>\n");
}
return $output;
}
Cheers,
jean
I fixed in your server, this problem happens when you don't have a correct foreign key for your tables, the fk should be defined like this structure (in your def files):
'fk' => {
'remote_table' => {
'this_column' => 'remote_column'
},
and below is the code;
Code:
sub { my $tags = shift;
my $id = $tags->{Category_ID};
my $table = $DB->table('catalog', 'catalog_sub_category');
$table->select_options ('ORDER BY Sub_Category');
my $sth = $table->select ([\"DISTINCT catalog.Sub_Category_ID", 'Sub_Category'],{ Category_ID => $id });
my $output;
my $num;
while (my $row = $sth->fetchrow_hashref) {
$num = $num + 1;
($output .= "<font face=\"verdana,arial,helvetica\" size=\"-2\" color=red>$num.</font> <font face=\"verdana,arial,helvetica\" size=\"-2\"><a href=db.cgi?&sid=$tags->{session_id}>$row->{Sub_Category}</a></font><br><br>\n");
}
return $output;
}
Cheers,
jean
