[thelist] ASP: 'Order By' question

Marc Seyon seyon at delime.com
Thu Jun 19 10:43:26 CDT 2003


Message from Casey Crookston (6/19/2003 09:59 AM)
>Using Access 2000 in an ASP app.  Very simple Select statement:
>
>"SELECT * FROM news ORDER BY date"
>
>Naturally, it orders from the smallest date (oldest) to the largest (most
>recent).  How do you get it to order it from largest to smallest?

ORDER BY date [ ASC | DESC ]

regards.
-marc

--
Carnival 2003 in all its photographic glory. Playyuhself.com
http://www.playyuhself.com/


More information about the thelist mailing list