CatalogManager.Query Returns Wrong Results (297056)


The information in this article applies to:

  • Microsoft Commerce Server 2000
This article was previously published under Q297056

SYMPTOMS

If you do not specify PropertytoSortOn, the CatalogManager.Query method returns the wrong results.

RESOLUTION

To resolve this problem, obtain the latest service pack for 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

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

This bug was corrected in Commerce 2000 Service Pack 1.

MORE INFORMATION

CatalogManager.Query takes the following parameters: 
Function Query(
strPhrase As String,
Optional strCatalogsToSearch As Variant,
Optional eClassTypeRequired As Variant,
Optional strPropertiesToReturn As Variant,
Optional strPropertyToSortOn As Variant,
Optional fSortAscending As Boolean,
Optional lStartingRecord As Variant,
Optional lRecordsToRetrieve As Variant,
Optional plTotalRecordsInQuery As Variant
) As _Recordset
This problem occurs when you set strPropertyToSortOn to be empty.
Modification Type:MajorLast Reviewed:10/21/2002
Keywords:kbbug KB297056
©2002 Microsoft Corporation. All rights reserved.