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

Re: [hagai] modifying search criteria

Quote Reply
Re: [hagai] modifying search criteria In reply to
Hi,

To be honest, I'm not really sure.

I just had a look at an example:

search.cgi?bool=or;Title=test;URL=something

..but that gives:

Code:
SELECT * FROM glinks_Links WHERE (ExpiryDate >= 1243667736 AND Title LIKE '%test%' AND URL LIKE '%something%' AND isValidated = 'Yes')

..we need:

Code:
SELECT * FROM glinks_Links WHERE (ExpiryDate >= 1243667736 AND (Title LIKE '%test%' OR URL LIKE '%something%') AND isValidated = 'Yes')

..so in short, I don't think its possible. I even did a bit more digging, and it seems like the "search" is actually done via:

Code:
my $link_sth = $links->query_sth($args);

..which I'm assuming is a GT::SQL object, but I don't really have the time of patience to try and work out what goes on in there =)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Subject Author Views Date
Thread modifying search criteria hagai 3612 May 29, 2009, 1:53 PM
Post Re: [hagai] modifying search criteria
Andy 3454 May 30, 2009, 12:25 AM