Microsoft KB Archive/935503

= Some items are not returned in the search results when you use CAML to create a query that uses the SPQuery class to retrieve Windows SharePoint Services 3.0 list items that contain a URL =

Article ID: 935503

Article Last Modified on 5/14/2007

-

APPLIES TO


 * Microsoft Office SharePoint Server 2007
 * Microsoft Windows SharePoint Services 3.0

-



SYMPTOMS
Consider the following scenario. You use Collaborative Application Markup Language (CAML) to create a query. The query uses the SPQuery class to retrieve items from a list on a Microsoft Windows SharePoint Services 3.0 site. The purpose of the query is to look for items that contain a URL in a particular column and then to retrieve those items. For example, the query looks for and retrieves items that contain a URL in the Hyperlink or Picture column. In this scenario, some items are not returned in the search results when you run the query.



CAUSE
This issue occurs if one of the following conditions is true:
 * The column contains a URL to the local Windows SharePoint Services 3.0 server.
 * The column contains a server name that is listed in the alternate access mappings.

If one of these conditions is true, the URL is not stored as an absolute URL. The URL is stored as a relative URL.



WORKAROUND
To work around this issue, make the URL a relative URL. To do this, remove the server name before the URL is passed to the query.



MORE INFORMATION
For more information about the SPQuery class, see the Windows SharePoint Services 3.0 Software Development Kit (SDK). To view the Windows SharePoint Services 3.0 SDK, visit the following Microsoft Web site:

http://msdn2.microsoft.com/en-us/library/ms441339.aspx

Or, to download the Windows SharePoint Services 3.0 SDK, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?familyid=05E0DD12-8394-402B-8936-A07FE8AFAFFD&displaylang=en

Additional query words: field fqdn fully qualified domain name

Keywords: kbprogramming kbtshoot kbprb kbexpertiseinter KB935503

-

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

© Microsoft Corporation. All rights reserved.