Absolutely a consideration - it may be too heavy a cost - depending on factors not included in the question.
In some cases however, there just is no replacement for the Query*() functions, but I concur this example isn't necessarily one of them. Speaking for myself, I appreciate being made aware of other techniques available on the platform, and using my own judgement as to the best tool for the job. Regards, -----Original Message----- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Wednesday, June 30, 2010 1:40 PM To: cf-talk Subject: Re: Order By question I respectfully disagree with this approach. Doing it in the db will be much faster. On Wed, Jun 30, 2010 at 3:06 PM, Jon Sala <jon.s...@albertahealthservices.ca > wrote: > > Exclude them from the query, > then append them with QueryAddRow() and QuerySetCell() > > > > -----Original Message----- > From: Les Mizzell [mailto:lesm...@bellsouth.net] > Sent: Wednesday, June 30, 2010 1:03 PM > To: cf-talk > Subject: Order By question > > > Not 100% sure how to do this... > > Need to return a list of folks ordered by last_name (no problem), > EXCEPT for 2 of them. They need to be LAST regardless of their last > names (problem)... > > Perhaps something with their 2 ID numbers? > > Ideas? > > > __________ Information from ESET NOD32 Antivirus, version of virus > signature database 5241 (20100630) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334981 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm