PRB: Searching Phrases with Numbers in MSIDXS OLE DB ProviderLast reviewed: March 6, 1998Article ID: Q179237 |
The information in this article applies to:
SYMPTOMSWhen using ActiveX Data Objects (ADO) with the OLE DB Provider for Index Server (MSIDXS) to query the contents of Index Server and you use a phrase where the first word starts with a number, Index Server may return incorrect hits. For example, when you search for the phrase '"32MB RAM"', Index Server may produce extra hits containing documents with just "RAM". The query '"32MB and RAM"' works correctly. Searching for other phrases such as '"SQL Server"' also works correctly.
CAUSEThis is a problem in the Index Server 2.0 query mechanism. Using an HTX/IDQ sample reproduces the same behavior.
RESOLUTIONYou can work around this problem by adding an additional word to the beginning of the phrase (for example, CONTAINS('"the 32MB RAM"') > 0 ). The following query works correctly:
SELECT Filename, Path, Size, Write FROM Scope('"/"') WHERE CONTAINS('"the 32MB RAM"') > 0 STATUSMicrosoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
MORE INFORMATIONSteps to Reproduce Behavior: Use ADO and the MSIDXS provider to submit the following query with different search phrases:
SELECT Filename, Path, Size, Write FROM Scope('"/"') WHERE CONTAINS('"32MB RAM"') > 0 ORDER BY Filename
REFERENCESFor more information on Index Server, please see the following articles in the Microsoft Knowledge Base:
ARTICLE-ID: Q179326 TITLE : FILE: Idxadovb.exe: Using Index Server OLE DB Provider and ADO ARTICLE-ID: Q178849 TITLE : INFO: Index Server OLEDB Provider Cannot Be Installed Separately Keywords : oledbProvIndex Technology : ole Version : WINDOWS:2.0 Platform : WINDOWS Issue type : kbprb |
================================================================================
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |