asc or desc after the field name
select ...
order by date desc
Alejandro Mozo Quesada
sistemas/programaci�n
http://www.tiza.net
educar divirtiendo
----- Original Message -----
From: "Herman Cremer" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Thursday, March 29, 2001 9:40 AM
Subject: order in MySQL
> Hey all.
>
> just a quick one.
>
> To order results from a MySQL DB, one uses
>
> SELECT ...
> ORDER BY...
>
> How can I select if the order should be ascending / descending ?
>
> Herman
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com