I am having trouble again with getting the correct addexp syntax. I need to be able to be able to query for terms with . _ - in the query term. I have the following addexp which I was hoping would take care of the issue.
Did you drop and remake the index in the same process that you set the addexp in? `set addexp' only applies to the current process.
Also, if you wish to search for `-' (hyphen) as a literal character and not use it as a phrase conjugator, then at search time you should `set hyphenphrase=0' so that hyphen is taken literally between words and not as a phrase indicator.
Depending on what you want you might use a slightly different expression to only get embedded punctuations and not those before or after:
\alnum{1,70}>>[+\-._/]=\alnum{1,70}
But did you drop and remake the indexes in the *same* tsql/texis invocation as `set addexp', i.e. all in one script/command-line? The `set addexp' value is lost unless the new index is created in the same process.
That looks correct. What is the full SQL you use for the search that gives the `Query 'jake.jacobson' would require post-processing' error? Also, are there any other indexes on janesMasterLogs(userid)?
How would I tell if there are any other indexes? I was thinking that might be the issue but didn't know how to test it out. Is there a query I can make to the SYSTEM tables in the database?
The query looks like:
<sql "UPDATE janesMasterLogs SET userdomain='mydomain' WHERE userid LIKE 'jake.jacobson'"></sql>