REX Alternate to - Logical Operator

Post Reply
kzinda
Posts: 62
Joined: Fri Nov 30, 2001 6:18 am

REX Alternate to - Logical Operator

Post by kzinda »

The application that was written for me takes my query terms and always constructs a query syntax in the form:

$Field like '+word1 +word2'

in which case I cannot use the "-" logical operator to remove a hit using the "must not include" term. Is there a way to generate a REX expression to emulate the must not include operator? My query generator does accept REX expressions.
User avatar
Kai
Site Admin
Posts: 1272
Joined: Tue Apr 25, 2000 1:27 pm

REX Alternate to - Logical Operator

Post by Kai »

Not really, if your script is always placing a `+' in front of each term. In any event such a REX expression would be unindexable and slow searches down.

Also, if the query is using LIKE as in your example, all terms are already required if they do not have a `+' or `-' (if there is no `@' operator), so I'm not sure why `+' is being prefixed unless something else is going on.

The best solution would be to drop the `+' prefixing, or at least edit the script to check for a leading `+' or `-' on search words first before prefixing a `+'.
Post Reply