|
| |
|
|
pmagas
Posts: 367 Joined: 3/26/2002 From: St. Louis MO USA Status: offline
|
'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!!
_____________________________
Penny humble webmaster of We Sell St. Louis http://www.WeSellStLouis.com http://www.MarkSellsStLouis.net http://www.St-Louis-Mo.info http://www.NealSellsStLouis.com
|
|
|
|
BeTheBall
Posts: 6381 Joined: 6/21/2002 From: West Point Utah USA Status: offline
|
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.
_____________________________
Duane Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
|
|
New Messages |
No New Messages |
Hot Topic w/ New Messages |
Hot Topic w/o New Messages |
Locked w/ New Messages |
Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|