Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Get Full

Jan 15, 2004, 4:45 AM

mkoenig

Novice (47 posts)

Jan 15, 2004, 4:45 AM

Post #1 of 7

Shortcut

Get Full_Name

Hello everybody

i am so stupid Frown

i want to use following global but i don't know how to get the Full_Name

sub {
my $output;
my $cat_db = $DB->table('Category');
my $cat_id = $_[0];
$cat_db->select_options('ORDER BY Full_Name');
my $sth = $cat_db->select ( {'Name' => $cat_id}, ['ID','Full_Name','Name'] );
while (my ($id,$cat,$heading) = $sth->fetchrow_array) {
my $linkdb = $DB->table('Links','CatLinks');
my $url = $cat_db->as_url($cat);

$output .= qq~$heading (<a href="/$url">FULL_NAME</a><br>)~;
}
return $output;
}

please help me again

Marina Frown

Jan 15, 2004, 5:57 AM

Andy

Veteran / Moderator (18436 posts)

Jan 15, 2004, 5:57 AM

Post #2 of 7

Shortcut

Re: [mkoenig] Get Full_Name In reply to

$output .= qq~$heading (<a href="/$url">$cat</a><br>)~;

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jan 15, 2004, 7:49 AM

mkoenig

Novice (47 posts)

Jan 15, 2004, 7:49 AM

Post #3 of 7

Shortcut

Re: [Andy] Get Full_Name In reply to

Thank you Andy

can i ask you another Question?

Where is my fault:

sub {
my $id = shift;
my $db = $DB->table('Category');
my $clean = $DB->table('Category')->select('Name', { ID => $id })->fetchrow;
my $url = $db->as_url($clean);
return $url;
}

i only want the Name of the category not the Full_Name

Marina

Jan 15, 2004, 8:03 AM

Andy

Veteran / Moderator (18436 posts)

Jan 15, 2004, 8:03 AM

Post #4 of 7

Shortcut

Re: [mkoenig] Get Full_Name In reply to

Code:
sub {  
  my $id = shift;   
  my $db = $DB->table('Category');   
  my $clean = $DB->table('Category')->select('Name', { ID => $id })->fetchrow;   

  my $url = $db->as_url($clean);  
  return $url;  
}