You could try something like:
<cfoutput>
<cfloop from="#query.recordcount#" to="1" index="i">
#query[column][i]#
</cfloop>
</cfoutput>
I may have swapped column and i -- I can never remember if it's a struct
of arrays or an array of structs. :-\
--Ben Doom
Tom King wrote:
> 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
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293386
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
