Microsoft KB Archive/935503

From BetaArchive Wiki
Knowledge Base


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:

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


Additional query words: field fqdn fully qualified domain name

Keywords: kbprogramming kbtshoot kbprb kbexpertiseinter KB935503