The information in this article applies to:
SYMPTOMSWhen you run the SQL sample that comes with Index Server 2.0 and query for a string with prefix expansion (such as 'CONTAINS(' "Inter*" ')>0'), the query results display correctly and you see "Summary" and "Full" links. However, no words are hit-highlighted. CAUSEThis is a problem in the way the Microsoft OLE DB Provider for Index Server 2.0 generates "Query Restriction" to handle use of hit-highlighting. This is caused by RS.Properties("Query Restriction") that returns '(@contents("Inter*"))'. RESOLUTIONCurrently there is no resolution to the problem. STATUSMicrosoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. We are researching this bug and will post new information here in the Microsoft Knowledge Base as it becomes available. MORE INFORMATION
Microsoft OLE DB Provider for Index Server 2.0 supports searching for
Prefix Expansion (wildcards) in the CONTAINS predicate of the WHERE clause
of a SQL statement.
REFERENCESFor more information on Index Server, please refer to Index Server documentation in the Windows NT Option Pack documentation. Additional query words: kbDSupport kbIndexServer kbDatabase kbOLEDB kbdse
Keywords : |
Last Reviewed: November 10, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |