Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Re: [sahertianr] Global to show Main Category (Father) of the subcategories.: Edit Log

Gossamer Threads

Home : Products : Gossamer Links : Development, Plugins and Globals :

Products: Gossamer Links: Development, Plugins and Globals: Re: [sahertianr] Global to show Main Category (Father) of the subcategories.: Edit Log

Here is the list of edits for this post

Oct 1, 2004, 11:46 PM

Andy

Veteran / Moderator (18441 posts)

Oct 1, 2004, 11:46 PM

Re: [sahertianr] Global to show Main Category (Father) of the subcategories.

You could try something like;

<%global_name($ID)%> (this will work in link.html).

Code:
sub { 

  my $ID = $_[0]; 
  my $FATHERID = $DB->table('CatLinks')->select( ['CategoryID'], { LinkID => $ID } )->fetchrow; 
  my $name = $DB->table('Category')->select( ['Name'], { ID => $FATHERID })->fetchrow; 

  $name ? return $name : return 'No name found'; 

}

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk

Last edited by:

Andy: Oct 2, 2004, 4:59 AM

Edit Log:

Post edited by Andy Post edited by Andy (Veteran) on Oct 2, 2004, 4:59 AM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676