Thread: ordering problem
View Single Post
  #1 (permalink)  
Old April 17th, 2008, 03:10 PM
todd2006 todd2006 is offline
Contributing Member

  
Join Date: Mar 2008
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 1
todd2006 is an unknown quantity at this point
Default ordering problem
Hi,

I dont want to display the current topic and i want to display the topics starting from 2008 and then going to 2000 or 1999

so i am sorting on topic date but its not working any idea

Code:
sqlstr="SELECT * FROM Topics WHERE (Topic_Date <> (SELECT TOP 1 Topic_Date FROM Topics WHERE Topic_Date <= getDate() ORDER BY Topic_Date desc)) order by Topic_Date desc"
when the topics are displayed they start at 2007 year and then 2008 and then 2006 and so on

todd