The query indexing syntax comes in handy... It lets you treat the query
as a big array.
So, you can use cfloop with an index (numeric values from
#queryName.recordCount# down to 1, so step -1) and get your column
values out by doing queryName[index].value (or is it
queryName.value[index]?)
Thanks
Mark
-----Original Message-----
From: Tom King [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 15, 2007 9: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:293378
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
