|
Home > Archive > Commerce Server General > December 2004 > Record not sorting correctly CS 2002
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Record not sorting correctly CS 2002
|
|
| Paula Blohm 2004-11-22, 5:48 pm |
| I am currently running Commerce Server 2002, standard edition. We are
current on the service packs.
I have an .asp page performing the following call:
set rsProductDetails =
Application("MSCSCatalog").GetProduct(strSku).variants("sortOrder")
The result set is not sorted. I have found a service pack for Commerce
Server 2000 that addresses this
problem but not one for Commerce Server 2002. We loaded Service Pack 3 for
Commerce Server 2002
and it did not fix the problem.
Does anyone have any ideas on how to return a sorted record set using the
above call?
Thanks,
Paula Blohm
| |
| Austin Skyles [MSFT] 2004-12-31, 5:48 pm |
| The following VBScript code, using CS2002 SP3 with the Adventure Works
Catalog correctly sorts the variants as requested.
Is it possible that you have modified your catalog schema or stored
procedures, or applied any hotfixes or other changes?
Are you sorting on a multilingual column?
Is it possible that the sort correct, but is using the wrong collation?
----
set catalog = catalogManager.GetCatalog("Adventure Works Catalog")
set variants = catalog.GetProduct("AW045-03").Variants("ProductColor")
variants.MoveFirst
do while NOT variants.EOF
WScript.echo variants("ProductColor")
variants.MoveNext
loop
---
Austin Skyles
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security.
Please reply to the newsgroups only. Thanks
--------------------
From: "Paula Blohm" <paula_blohm@b-f.com>
Subject: Record not sorting correctly CS 2002
Date: Mon, 22 Nov 2004 11:23:40 -0500
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
Message-ID: <Ok7M5$K0EHA.1404@TK2MSFTNGP11.phx.gbl>
Newsgroups: microsoft.public.commerceserver.general
NNTP-Posting-Host: n33.b-f.com 12.154.100.33
Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11
.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:15138
X-Tomcat-NG: microsoft.public.commerceserver.general
I am currently running Commerce Server 2002, standard edition. We are
current on the service packs.
I have an .asp page performing the following call:
set rsProductDetails =
Application("MSCSCatalog").GetProduct(strSku).variants("sortOrder")
The result set is not sorted. I have found a service pack for Commerce
Server 2000 that addresses this
problem but not one for Commerce Server 2002. We loaded Service Pack 3 for
Commerce Server 2002
and it did not fix the problem.
Does anyone have any ideas on how to return a sorted record set using the
above call?
Thanks,
Paula Blohm
|
|
|
|
|