Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

search in cat and subcats only , the 4th.

Quote Reply
search in cat and subcats only , the 4th.
Again im hanging about this problem never solved before:
at the moment i see two ways to do:

First as mentioned in another thread; searching all but restrict the passed values to them from actuall cat, and all subcats, while doing an extra loop for the ids in CategoryAlternates.

The second solution, but more tricky, is to add another WHERE-Clause to sub query in dbsql.
Something like:

if ($in->('Category') then:

later ...

WHERE $where AND $where2

Now for this second $where2

In words we need:

Select all the links [and the links from CategoryAlternates where CategoryID=from actual or subs)
from Links WHERE $where AND WHERE CategoryID = actual or subcat.

Im trying this with a) the parameter IN ('a',...,'z')
or with the parameter EXITS and some other SELECTs inside.

I would be very glad if Alex could do some work on this, cause he will solve it shurely in minutes, while i will sit here for the next days. And cause so many users would like to have this mod; there is a real must for this.

Maybe some other people would like to collect some money to let this be done; i really dont have the time at the moment to spend some days on this; but as i have see Alex has nothing done on it in the last month though it is one of the most wished mod.

Some ideas to do it better or translate my thoughts into perl?

I will search and download now the old links 2.0 mod, maybe i will find there some ideas to it better.

Robert


Subject Author Views Date
Thread search in cat and subcats only , the 4th. Robert 2865 Sep 3, 2000, 4:52 AM
Thread Re: search in cat and subcats only , the 4th.
pugdog 2785 Sep 3, 2000, 9:34 AM
Thread Re: search in cat and subcats only , the 4th.
Robert 2814 Sep 5, 2000, 12:55 AM
Post Re: search in cat and subcats only , the 4th.
pugdog 2768 Sep 5, 2000, 11:39 AM