GT::SQL::Table (140): Wrong argument passed to this subroutine. Must pass category id to children at blahblahblah/Category.pm line 404. Any ideas as per why the cat is not passed to the children?I also used both ($ID) and ('ID') in the tag....just as a side note as well.What my ultimate goal for this is to show 6 categories on a seperate page with all new links below each category including the breadcrumb for each link. Like this:
catname: subcatname: sub sub cat name: sub sub sub catname (all linked)
Link.html information for that one link

Thanks Brian

I use this code

sub

{

my $cat = shift;

my ($output,$sth,$link);

my $all_ids = $DB->table('Category')->children($cat);

push @$all_ids, $cat;

my $search_db = $DB->table('Links','CatLinks','Category');

$search_db->select_options ('ORDER BY Add_Date DESC Limit 10');

$sth = $search_db->select (['Links.*'], GT::SQL::Condition->new(['CategoryID', 'IN', $all_ids], ['isValidated', '=', 'Yes', 'isNew', '=', 'Yes']) ) || return $GT::SQL::error;

my $output = qq~<br><hr>~;

while ($link = $sth->fetchrow_hashref)

{

my $category_url = $CFG->{build_root_url}."/".$link->{'Full_Name'}."/";

my $detailed_url = "$CFG->{build_detail_url}/$link->{'ID'}$CFG->{build_extension}";

$output .= Links::SiteHTML::display('link', $link);

}

return $output;

}

The problem is when I insert the same link for 2 or 3 category I get the same link more than one time in the list of the new link.