You could put them in descending order with ORDER BY value DESC
J.
John Wilker
Web Applications Consultant
Macromedia Certified ColdFusion Developer
www.red-omega.com <http://www.red-omega.com>
"Pessimism - Every dark cloud has a silver lining, but lightning kills
hundreds of people each year who are trying to find it." ~despair.com
-----Original Message-----
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 10:33 AM
To: CF-Talk
Subject: Order By
How can I display an output in reverse order by?
I want only the last record to be displayed.
Thansk for your help,
Rich
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists