Skip to main content.
home | support | download

Back to List Archive

Re: from the too lazy to do it in indexing department (remove

From: Brad Miele <brad(at)>
Date: Tue Feb 24 2004 - 17:14:55 GMT
yeah, sorry.

It is complex (of course)

I will split the processes to indexing and search.

The gist of the system is that different sites(sphotog) can share images
with each other. when i run the indexing script, it creates an array based
on the sites that are in the system, and loops through that list doing a
select on each site, and, as I am typing this, I am, in fact, realizing
where the error is, so, I will really not need to go into it further, for,
just putting it out to the list like this, much like the biweekly visists
to my overpaid shrink, where I babbly, and she scribbles, has allowed me
to see my problem from a new perspective.

Thanks Bill!

 Brad Miele
 Technology Director
 (207) 828-8787 x110

 Religion has done love a great service by making it a sin.
		-- Anatole France

On Tue, 24 Feb 2004, Bill Moseley wrote:

> On Tue, Feb 24, 2004 at 08:43:27AM -0800, Brad Miele wrote:
> > my @search_sites = ('Foo','Bar');
> > $query = qq[(($query) and sphotogs=(].join(' OR ',@search_sites).qq[))];
> >
> > The problem with this is that in records that have both Foo and Bar as
> > entries, i get duplicate results.
> I guess I don't follow.  Swish-e returns lists of files (or records if
> you like that name better).  It won't return duplicates unless you have
> indexed the same thing twice (or in two different indexes).
> > I can't seem to build the right boolean to remove the doplicates. If id
> > try to do  "not (Foo and Bar)", i lose the record alltogether.
> You might need to provide an example.
> --
> Bill Moseley
Received on Tue Feb 24 09:14:55 2004