FIX: Search Results Returned by CatalogManager.Query Are Not Ordered Correctly (301368)


The information in this article applies to:

  • Microsoft Commerce Server 2000 SP1
This article was previously published under Q301368

SYMPTOMS

When you use the CatalogManager.Query method and specify the strPropertyToSortOn parameter, the search results are not in order and do not match the sort order specified by strPropertyToSortOn.

RESOLUTION

To resolve this problem, obtain the latest service pack for Microsoft Commerce Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

297216 INFO: How to Obtain the Latest Commerce Server 2000 Service Pack

The English version of this fix should have the following file attributes or later:

   Date         Time      Version    Size           File name     
   -------------------------------------------------------------------
   08.Jun.2001 15:58:46  4.0.2052.0  467,216 bytes  Catalog.dll
   24.Jul.2001 13:23:06               68,392 bytes  CatalogUpgrade.sql

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Microsoft Commerce Server 2000 Service Pack 2.

MORE INFORMATION

To install this hotfix, you must have Commerce Server Service Pack 1 (SP1) installed. This hotfix updates the following components:
  • Catalog.dll
  • Stored procedures for catalogs that already exist
The catalog runtime DLL must be updated on all servers where the Commerce Server 2000 runtime components are installed. The stored procedures must be updated for all databases currently storing catalog data. You do not need to re-run any of the steps outlined in this article for catalogs created or imported after you apply this hotfix.

To update the Catalog.dll file, apply the following steps on all servers that have the Commerce Server runtime components installed:
  1. Unzip the contents of the hotfix to any folder.
  2. Run the HotfixSetup.exe file and follow the instructions.

    NOTE: This step only updates the Catalog.dll file. None of the stored procedures for existing catalogs are updated.


To update the stored procedures for existing catalogs, perform the following steps on all Commerce Server databases for all SQL Server computers that hold catalog data:
  1. Unzip the contents of the hotfix to any folder.
  2. Start the SQL Query Analyzer and connect to the SQL Server computer that holds the catalog.
  3. Select the database that belongs to your Commerce Server site.
  4. Open the CatalogUpgrade.sql file.
  5. Run the complete query.

Modification Type:MinorLast Reviewed:9/26/2005
Keywords:kbHotfixServer kbQFE kbbug kbCommServ2000preSP2fix kbCommServ2000SP2fix kbfix KB301368
©2004 Microsoft Corporation. All rights reserved.