Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Translate sql-query into links2 global

Oct 7, 2004, 5:34 AM

rsahertian

User (142 posts)

Oct 7, 2004, 5:34 AM

Post #1 of 6

Shortcut

Translate sql-query into links2 global

Can anybody translate this into a global?

select Title, LinkOwner from lsql_links where ID BETWEEN "300" AND "1000" and Title LIKE "%<%Title%>%" ;

I inserted content from a third party and using this for a special purpose!
I want to use this in the Link.html template.

Thanks,
Ron

Last edited by:

rsahertian: Oct 7, 2004, 5:36 AM

Oct 7, 2004, 6:14 AM

Andy

Veteran / Moderator (18441 posts)

Oct 7, 2004, 6:14 AM

Post #2 of 6

Shortcut

Re: [rsahertian] Translate sql-query into links2 global In reply to

Something like this should get your started :)

Code:
sub { 

  my $tags = shift; 
  my $title = $tags->{Title}; 

  my $cond = GT::SQL::Condition->new('ID','>=','300','ID','<=','1000'); 
     $cond->bool('AND'); 

  my $cond2 = GT::SQL::Condition->new('Title','LIKE',"%$title%"); 
  my $sth = $DB->table('Links')->select( ['Title','LinkOwner'], $cond2, $cond ) || die $GT::SQL::error; 

  while (my $hit = $sth->fetchrow_hashref) { 
     print "Title: " . $hit->{Title} . "<BR>"; 
  } 

}

Call with <%global_name%>

Cheers

Andy (mod)
andy@ultranerds.co.uk

Oct 7, 2004, 7:01 AM

rsahertian

User (142 posts)

Oct 7, 2004, 7:01 AM

Post #3 of 6

Shortcut

Re: [Andy] Translate sql-query into links2 global In reply to

Hi Andy,

Thanks for responding...

NO result and also NO error with your code!
Must it show always it's own Title with this piece of code???

thanks,
ron

Oct 7, 2004, 11:53 PM

sahertianr

Novice (27 posts)

Oct 7, 2004, 11:53 PM

Post #4 of 6

Shortcut

Re: [rsahertian] Translate sql-query into links2 global In reply to

Sorry Andy,

Just tested it out at home again and the query works.

But there is a small problem with it. I placed it it link.html so every link must produce it's similar link. But the global produces one list on top of the category!!!. How is that possible????

Thanks,
Ron

Oct 8, 2004, 12:12 AM

Andy

Veteran / Moderator (18441 posts)

Oct 8, 2004, 12:12 AM

Post #5 of 6

Shortcut

Re: [sahertianr] Translate sql-query into links2 global In reply to

Glad to hear its working. It was only an example though Wink

Try something like;

Code:
  my $back; 
  while (my $hit = $sth->fetchrow_hashref) { 
      $back .= "Title: " . $hit->{Title} . "<BR>";  
  } 

  return $back;

Andy (mod)
andy@ultranerds.co.uk

Oct 8, 2004, 12:20 AM

sahertianr

Novice (27 posts)

Oct 8, 2004, 12:20 AM

Post #6 of 6

Shortcut

Re: [Andy] Translate sql-query into links2 global In reply to

amazing.....