Microsoft KB Archive/939309

= No items are returned in the search results when you run an SQL query that contains an OR clause to search for items in document libraries in SharePoint Server 2007 =

Article ID: 939309

Article Last Modified on 8/31/2007

-

APPLIES TO


 * Microsoft Office SharePoint Server 2007

-



SYMPTOMS
Consider the following scenario. You create two columns in two different document libraries in Microsoft Office SharePoint Server 2007. The columns have the same name. However, the columns use different data types. For example, you create two columns that are named Test. The data type of one column is set to Number. Additionally, the data type of the other column is set to Data. You run an SQL query that contains an OR clause to search for items in the columns. However, no items are returned in the search results.



CAUSE
This issue occurs if the SQL query does not return search results in which properties are missing.



RESOLUTION
To avoid this issue, use unique column names.

Additional query words: moss moss2007

Keywords: kbtshoot kbprb KB939309

-

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

© Microsoft Corporation. All rights reserved.