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:
- Unzip the contents of the hotfix to any folder.
- 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:
- Unzip the contents of the hotfix to any folder.
- Start the SQL Query Analyzer and connect to the SQL Server computer that holds the catalog.
- Select the database that belongs to your Commerce Server site.
- Open the CatalogUpgrade.sql file.
- Run the complete query.
Additional query words: pagedresults
Keywords: kbbug kbfix kbcommserv2000presp2fix kbqfe kbcommserv2000sp2fix kbhotfixserver KB301368
