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:334977 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm