William Raymond
|
| Posted: 04/15/2002, 11:27 AM |
|
Hello,
I am using CC 2.0.5 w/SQL Server 2000 and ASP (no templates). I am
displaying a list of months from a view in SQL Server. The view sorts the
months by "Month ID", so it displays them in order (January, February,
March, April, etc.) However, CodeCharge is displaying the month names by
their order (April, August, etc.)!
Does anyone know why this is happening and how to fix it? I tested the CC
connection to make sure I am pointing to the right database and I opened the
view up in SQL Server to verify that it is indeed sorting. All should be
fine, yet the ASP page still sorts the wrong way.
Thanks,
-Bill
--
Bill Raymond
Project MVP
braymond@officecollab.com
Office Collaborators, Inc.
http://www.mvps.org/project/
|
|
|
 |
Doru Apostolescu
|
| Posted: 04/16/2002, 1:41 AM |
|
Use a custom SQL in CC to display the form with the corect order.
--
Doru APOSTOLESCU
Certified NT Admin
TEHNOPLUS Ltd.
doru@tehnoplus.com
"William Raymond" <braymond@officecollab.com> wrote in message
news:a9f61r$gb$1@news.codecharge.com...
> Hello,
>
> I am using CC 2.0.5 w/SQL Server 2000 and ASP (no templates). I am
> displaying a list of months from a view in SQL Server. The view sorts the
> months by "Month ID", so it displays them in order (January, February,
> March, April, etc.) However, CodeCharge is displaying the month names by
> their order (April, August, etc.)!
>
> Does anyone know why this is happening and how to fix it? I tested the CC
> connection to make sure I am pointing to the right database and I opened
the
> view up in SQL Server to verify that it is indeed sorting. All should be
> fine, yet the ASP page still sorts the wrong way.
>
> Thanks,
>
> -Bill
>
> --
> Bill Raymond
> Project MVP
>braymond@officecollab.com
> Office Collaborators, Inc.
>
> http://www.mvps.org/project/
>
>
>
>
|
|
|
|
|
