Ben Nadel has a queryToArray function. I suppose you could convert the query to an array then call up each "row" in reverse order a little eaiser, although I haven't tried it myself. http://www.bennadel.com/snippets/24-QueryToArray-qRecordSet-.htm
Or, you could add a 'DESC' to the end of your SQL statement's ORDER BY statement :) Ryan > -----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 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293387 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
