If you are using CF5 or higher, you can use QofQ. If you are using MX, I've even got a UDF for it...
<cfset query = querySort(query,"new column to sort by")> ======================================================================= Raymond Camden, ColdFusion Jedi Master for Hire Email : [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Brian Scandale [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 23, 2002 3:33 PM > To: CF-Talk > Subject: Re-Sort a Query... > > > I want to Re-Sort a Query that I have added several columns > of data to... > It is the new columns that I would like to sort by and I > can't go back to the database to use it's sorting routines. I > need to do this in CF. > > Browsing the docs I'm not seeing anything obvious. Thanks. > > > > At 10:08 AM 9/23/02, you wrote: > >That looks very promising! and jeeze... right under my nose > the whole time. That's embarrassing. Thanks Jochem > > > >At 01:53 AM 9/23/02, you wrote: > >>Brian Scandale wrote: > >>> How do I go about adding a column to a query dataset? > >> > >>QueryAddColumn()? > >> > >>Jochem > >> > >> > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
