multiple query terms

webinatoruser · Post by **webinatoruser** » Thu Jun 09, 2005 4:00 pm

I want to allow users to search within results. I have it working except where there are proximity searches already in the current query. For example if the current query is: query w/25 query2

and then in that result set, user wants to add another term like query 3, that is seen as part of the proximity expression in the first search. I tried to put the first expression in parenthesis and it didn't seem to work. I swear I looked through all the docs and the board before posting and I couldn't find any examples.

Post by **mark** » Thu Jun 09, 2005 5:02 pm

You can't really do different within's in a single query.
You would have to set it up to do that at the sql level in the script and OR the 2 queries together or do the second query ANDed with the list of record ids from the first query. The latter method would be more amenable to doing more refinements on a refined query. Not sure which method might be faster. Would probably depend somewhat on the queries.