Microsoft KB Archive/257654

= Site Server Rule Editor Constructs Incorrect Query Logic =

Article ID: 257654

Article Last Modified on 6/12/2001

-

APPLIES TO


 * Microsoft Site Server 2.0 Standard Edition
 * Microsoft Site Server 3.0 Standard Edition

-



This article was previously published under Q257654



SYMPTOMS
The Site Server Rule Editor constructs an incorrect query syntax in the .prf file for viewing documents tagged with multiword values for a property. When a user tries to browse the view page, the .prf file cannot be executed and the following error message is returned:

Microsoft OLE DB Provider for Microsoft Index Server error '80040e14' Incorrect syntax near for. Expected '''. SQLSTATE=42000



CAUSE
This problem occurs because the Rule Editor incorrectly constructs the search string as follows:

Contains(contenttype,'"community services and resources*"')>0

The search string needs to be in nested quotes, as in the following example:

Contains (contenttype,'community services and resources*')>0



WORKAROUND
To work around this problem, open the .prf file and manually add the extra quotes around the multiword or wildcard phrase. For example, if the generated .prf file contains the following the search string: Contains (contenttype,'community services and resources*')>0 Change the search string to the following:

Contains(contenttype,'"community services and resources*"')>0

Note: If a new view page is generated, you need to redo this step.

Keywords: kbprb KB257654

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.