ASC-DESC

1 Apr 2006 3:25 AM

gurvar

Hi,
The Asc or Desc functions work well on the sql server, but when I try to use
the parameters collection through ASP.NEt . The SQL statements doesn't
execute the same way. Ex: I'm trying to sort months say as 1-Jan,2-Feb etc.
on ASP page I get is as 1 Apr, 8 Aug etc. The sql stmt ends ass ORDER BY
month(date) DESC & works well.
Thanks.

1 Apr 2006 12:04 PM

Cor Ligthert [MVP]

Gurvar,

I have read it fout times and I know now what works. What does not work?

Cor

1 Apr 2006 1:05 PM

Terry Burns

:-D

I read it about four times as well , I think you have your date in the wrong
culture and its sorting the days as months. One way is to convert the date
to a serial

--
Terry Burns
http://TrainingOn.net

Show quote

"Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
news:etpKqQYVGHA.4900@TK2MSFTNGP12.phx.gbl...
> Gurvar,
>
> I have read it fout times and I know now what works. What does not work?
>
> Cor
>