If you have created your query manually, why not add another field that
will let you sort the records as desired?
However, if you just want to reverse the order of the returned
records...
<cfloop from="#query.recordCount#" to="1" index="thisRecord">
#query["column"][thisRecord]#<br>
</cfloop>
M!ke
-----Original Message-----
From: Tom King [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 15, 2007 8:04 AM
To: CF-Talk
Subject: Cfoutput query backwards
Hi All,
Is there a way of outputting a Query in cfoutput in reverse without
creating another query, or adding rows to the query, and with no
numerical index?
I have a "manual" query object created, with galleryId, and galleryName,
but GalleryID is not a sequential number sequence nor alphabetical, so
ORDER BY galleryID doesn't have the correct effect;
ie. values might be:
ID Name
2007_foo Foobar
2007_abc FooFoo
Obviously, when I CFDUMP the query, you get CF's ID in the column, and
outputting QueryName.currentrow will give you a sequential numerical
list, but I want CF to output that Query in reverse!
Any ideas?
Thanks
T
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293383
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
