Microsoft KB Archive/301368

= FIX: Search Results Returned by CatalogManager.Query Are Not Ordered Correctly =

Article ID: 301368

Article Last Modified on 9/26/2005

-

APPLIES TO


 * Microsoft Commerce Server 2000 Service Pack 1

-



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.

Additional query words: pagedresults

Keywords: kbbug kbfix kbcommserv2000presp2fix kbqfe kbcommserv2000sp2fix kbhotfixserver KB301368

-

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

© Microsoft Corporation. All rights reserved.