Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [Andy] Subcategories by ID?

Quote Reply
Re: [Andy] Subcategories by ID? In reply to
Oh thanks.

I've changed the red text. Is that right?


sub {

my $cat = $_[0];
my $all_ids = $DB->table('Category')->children($cat);
push @$all_ids, $cat;

my $db_obj = $DB->table('Category');
$db_obj->select_options ('ORDER BY Full_Name DESC');

my $sth = $db_obj->select ( GT::SQL::Condition->new('ID', 'IN', $all_ids) ) || die $GT::SQL::error;

my @cats;
while (my $hit = $sth->fetchrow_hashref) {
$hit->{URL} = $CFG->{build_root_url} . "/" . $DB->table('Category')->as_url( $hit->{Full_Name} ) . "/" . $CFG->{build_index};
push @cats, $hit;
}

return { cats_loop => \@cats }

}


Now I tried your script. I cann see the links Cool
but under any link is this text:
Error: Unmatched endif/endifnot/endunless tag
Subject Author Views Date
Thread; hot thread Subcategories by ID? Knubbel 8796 Jul 7, 2008, 6:23 AM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8648 Jul 7, 2008, 7:13 AM
Thread; hot thread Re: [Andy] Subcategories by ID?
Knubbel 8645 Jul 7, 2008, 7:23 AM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8617 Jul 7, 2008, 7:29 AM
Thread; hot thread Re: [Andy] Subcategories by ID?
Knubbel 8626 Jul 7, 2008, 7:36 AM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8656 Jul 7, 2008, 7:43 AM
Thread; hot thread Re: [Andy] Subcategories by ID?
Knubbel 8610 Jul 7, 2008, 8:01 AM
Post; hot thread Re: [Knubbel] Subcategories by ID?
Knubbel 8604 Jul 7, 2008, 8:09 AM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8646 Jul 7, 2008, 8:09 AM
Thread; hot thread Re: [Andy] Subcategories by ID?
Knubbel 8611 Jul 7, 2008, 8:23 AM
Post; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8617 Jul 7, 2008, 8:25 AM
Thread; hot thread Re: [Andy] Subcategories by ID?
Knubbel 8608 Jul 7, 2008, 8:31 AM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Knubbel 8598 Jul 7, 2008, 10:44 PM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8587 Jul 7, 2008, 11:31 PM
Thread; hot thread Re: [Andy] Subcategories by ID?
Knubbel 8594 Jul 7, 2008, 11:46 PM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8612 Jul 7, 2008, 11:56 PM
Thread; hot thread Re: [Andy] Subcategories by ID?
Knubbel 8602 Jul 8, 2008, 12:21 AM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8603 Jul 8, 2008, 12:26 AM
Thread; hot thread Post deleted by Knubbel
Knubbel 8580 Jul 8, 2008, 12:36 AM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8596 Jul 8, 2008, 12:39 AM
Thread; hot thread Post deleted by Knubbel
Knubbel 8593 Jul 8, 2008, 12:47 AM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8647 Jul 8, 2008, 12:54 AM
Thread; hot thread Re: [Andy] Subcategories by ID?
Andy 8591 Jul 8, 2008, 1:14 AM
Thread; hot thread Re: [Andy] Subcategories by ID?
Knubbel 8559 Jul 8, 2008, 2:04 AM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8555 Jul 8, 2008, 2:07 AM
Thread; hot thread Re: [Andy] Subcategories by ID?
Knubbel 1586 Jul 8, 2008, 2:18 AM
Post; hot thread Re: [Knubbel] Subcategories by ID?
Andy 1587 Jul 8, 2008, 2:20 AM