'Order By' Question (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message


pmagas -> 'Order By' Question (9/15/2005 14:09:42)

I have a DRW (on the Spooky diet) with an Order By and everything works fine. [:)] I'd like to add another order by in there. Can I do that? And what's the syntax?

Not sure if I'm clear - I want it to order by status (ascending), then within status, I want to order it by date (descending.) But I don't know if it can be done and I'm not sure how to write it without 'wrecking' everything. The good news is that since it's not broken, it's not urgent.

Thanks for any guidance you might offer.

Cheers!!




BeTheBall -> RE: 'Order By' Question (9/15/2005 15:47:30)

Like this:

ORDER BY status asc, date desc

Change status and date to the actual field names.




pmagas -> RE: 'Order By' Question (9/15/2005 15:49:34)

Thank you, thank you, thank you!! Have a great one!!!

Cheers!




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875