Interesting Search Exception: " and x
I've run into some weirdness with my free-text searching. When using the search term " and [insert anything here] the following exception is thrown: "
Syntax error near 'x' in the full-text search condition 'formsof(inflectional, """) and formsof(inflectional," x")'.
"
As you can see, it doesn't seem to be escaping the " character in any way, breaking the statement. For some reason it does work just fine using " OR x. HTML Encoding the string first will keep this from breaking, but will not match the " to any product with a " in it.
Any thoughts?
Hi Peter,
The FTS query is build in the ctlg_GetFTSQuery stored procedure. In that procedure it is replacing instances of the word 'and' with the formsof function. It is likely that the phrase you are entering isn't being parsed correctly by that procedure. If you turn on SQL Profiler and watch for a call and the result from that query along with the companion call to GetResults (or GetResults_For_SingleCatalog) you will see a malformed SQL call. Your best bet is to ensure that you can consistently reproduce the problem, open a support case, and they will investigate if this needs a hotfix.
Cheers,
Colin
