Site Server Rule Editor Constructs Incorrect Query Logic (257654)

The information in this article applies to:

Microsoft Site Server 2.0
Microsoft Site Server 3.0

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.

Modification Type:	Major	Last Reviewed:	6/12/2001
Keywords:	kbprb KB257654