Gossamer Forum: Products: Gossamer Links: Discussions: <%categoryID%> to call all categories

Aug 14, 2003, 3:59 PM

ccunet

User (353 posts)

Aug 14, 2003, 3:59 PM

Post #1 of 10

Shortcut

<%categoryID%> to call all categories

Is there are tag similar to <%categoryID%> to call all the categories at the same time?

CCUnet
my Christian web

Aug 15, 2003, 1:45 AM

Andy

Veteran / Moderator (18441 posts)

Aug 15, 2003, 1:45 AM

Post #2 of 10

Shortcut

Re: [ccunet] <%categoryID%> to call all categories In reply to

Could you explain yourself a little bit more? You were a bit brief Unsure

Cheers

Andy (mod)
andy@ultranerds.co.uk

Aug 15, 2003, 8:33 AM

ccunet

User (353 posts)

Aug 15, 2003, 8:33 AM

Post #3 of 10

Shortcut

Re: [Andy] <%categoryID%> to call all categories In reply to

Andy,

I'm trying to build a page using pagebuilder that has all the links that have a column isPriority set to yes.

Since pagebuilder simple pages do not seem to support the <%link%> and <%category%. tags i have to use a pagebuilder category page.

However that restricts me to only one category using <$categoryID%> ex page.cgi?page=partners;category=<%categoryID%>

So I am trying to find away to call all the categories like so page.cgi?page=partners;category=all.

Hope that makes sense. There may be a better way to do it but that is what I've come up with.

Thanks for the help

CCUnet
my Christian web

Aug 15, 2003, 9:13 AM

Andy

Veteran / Moderator (18441 posts)

Aug 15, 2003, 9:13 AM

Post #4 of 10

Shortcut

Re: [ccunet] <%categoryID%> to call all categories In reply to

Could you not do it with a simple global, or plugin? Something like;

Code:
sub { 

  my $table = $DB->table('Links'); 
  my $sth   =  $table->select( { isPriority => 'Yes' } ) or return "Error: $GT::SQL::error"; 

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

  while (my $hit = $sth->fetchrow_hashref) { 
    $link = $db->select ('*', { ID => $hit->{ID} })->fetchrow_hashref; 

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

  } 

return $output; 

}

That should return all the links in your database with 'isPriority' set to 'Yes'

Hope that helps Smile

Cheers

Andy (mod)
andy@ultranerds.co.uk

Aug 15, 2003, 10:49 AM

ccunet

User (353 posts)

Aug 15, 2003, 10:49 AM

Post #5 of 10

Shortcut

Re: [Andy] <%categoryID%> to call all categories In reply to

Andy,

I tried the sub as a global named link_partners and called like this

Code:

<%link_partners%>
<%loop link_partners%>
<a href="http://www.mysite.com/cgi-bin/jump.cgi?<%ID>"><%Title%></a> 
<%Description%><
link partner<%include link_partners%>
<%loop link_partners%>
<a href="http://www.mychristianweb.com/cgi-bin/guide/jump.cgi?<%ID>"><%Title%></a> 
<%Description%> 
<%endloop%>

but the page just chokes and never displays.

thanks

CCUnet
my Christian web

Aug 15, 2003, 10:54 AM

Andy

Veteran / Moderator (18441 posts)

Aug 15, 2003, 10:54 AM

Post #6 of 10

Shortcut

Re: [ccunet] <%categoryID%> to call all categories In reply to

Why the loop?

Try;

<%if link_partners%>
<%link_partners%>
<%endif%>

Cheers

Andy (mod)
andy@ultranerds.co.uk

Aug 15, 2003, 11:05 AM

ccunet

User (353 posts)

Aug 15, 2003, 11:05 AM

Post #7 of 10

Shortcut

Re: [Andy] <%categoryID%> to call all categories In reply to

Andy,

I was just following a previous example I had. trying to learn how to do this for myself.

anyway I got this error

Unable to compile 'link_partners':

CCUnet
my Christian web

Aug 15, 2003, 11:10 AM

Andy

Veteran / Moderator (18441 posts)

Aug 15, 2003, 11:10 AM

Post #8 of 10

Shortcut

Re: [ccunet] <%categoryID%> to call all categories In reply to

Sorry, a boo boo on my end Tongue

Try changing;

$link = $db->select ('*', { ID => $hit->{ID} })->fetchrow_hashref;

to

$link = $table->select ('*', { ID => $hit->{ID} })->fetchrow_hashref;

Cheers

Andy (mod)
andy@ultranerds.co.uk

Aug 15, 2003, 11:23 AM

ccunet

User (353 posts)

Aug 15, 2003, 11:23 AM

Post #9 of 10

Shortcut

Re: [Andy] <%categoryID%> to call all categories In reply to

That did the trick Andy. Thanks

I'll need to dissect this code to learn how it works

CCUnet
my Christian web

Aug 15, 2003, 11:27 AM

Andy

Veteran / Moderator (18441 posts)

Aug 15, 2003, 11:27 AM

Post #10 of 10

Shortcut

Re: [ccunet] <%categoryID%> to call all categories In reply to

Its pretty simple. All it does, is go through the database and find links where 'isPriority' => 'yes', and then go through a loop. It then grabs each links details, and passes it to LSQL's template parsing system. You can change the template it uses if you want too :)

Cheers

Andy (mod)
andy@ultranerds.co.uk