ASC-DESC

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Gurvar,

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

Cor
 
:-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
 
Back
Top