On our web server we have a search form that fires off multiple searches and combines the results into 1 page. The main search is of the indexing catalog for our web site. We have used this for several years and it works just fine. The company just sponsored a weight loss program and we have discovered that the word "weight" returns an error. The word "weigh" works fine but if we add that "t" on the end it fails. Here is the error:
Incorrect syntax near 'weight'. Expected '!', '(', NOT, ISABOUT, FORMSOF,
STRING, PREFIX_STRING. SQLSTATE=42000
This is the query at the time of execution:
Select DocTitle,URL from SCOPE()
where (CONTAINS(CONTENTS, 'weight') OR CONTAINS(DocTITLE, 'weight')) order by
Does anyone have an idea of how to get past this problem? I'm guessing that "weight" is probably a key word or something similar.
View Complete Post