Re: [aseek-users] Restricting search results

From: Kir Kolyshkin (no email)
Date: Tue Jan 21 2003 - 11:41:52 EST


Hmmm...

Subset wildcards are actually in SQL LIKE. So, if you put a subset
http://something.com/some/%, the query that will select all UrlIDs
matching that subset will be:

SELECT url_id FROM urlword WHERE url LIKE 'http://something.com/some/%'
   AND status=200 AND deleted=0

This SELECT is performed during index -B (generating subsets). Result as
a sorted array of UrlIDs is put into the file
var/<DBName>//subsets/sub<subset_id>.

And the only meta-characters that can be put into LIKE are:

_ - any single character
% - sequence of any characters

So, if you can implement what you need using this functionality and/or info
about internals of ASPseek I have provided - fine!

Valentine wrote:
> Greetings!!!
>
>
> I have encountered a dilemma
>
> there is a site
>
> http://localhost
> and there exists a password protected page.
>
> http://localhost/protected/
>
> I create two subsets
>
> http://localhost/%
> http://localhost/protected/%
>
> but I do not want protected to be in the root subset.
>
> The question is, is it possible to restrict search results not to include some subset?
>
> ie.
> <input type="hidden" name="exclude_url" value="http://localhost/protected/% />
>
>
> thanks,
> val.
>

-- 
== kir_at_asplinux.ru == 7551596_at_ICQ == 6722750_at_sms.beemail.ru ==
Stuckness  shouldn't be avoided.  It's the psychic  predecessor of all
real understanding.  An egoless acceptance of stuckness is a key to an
understanding of all Quality, in mechanical work as in other endeavors.
               -- R. Pirsig, "Zen and the Art of Motorcycle Maintenance"







Hosted Email Solutions

Invaluement Anti-Spam DNSBLs



Powered By FreeBSD   Powered By FreeBSD