this is odd
if i do this
<cfset newOrderList = ",'Partner','Principal','Senior
Associate','Associate',">

ORDER BY CHARINDEX(',' + Title + ',' , '#newOrderList#'), Fullname;

it basically doesnt even put in the Title as a Order By Item...

so my group by in the outputs dont work..
oh well.

i can fake this one..
look like a good time to use QaQ

-paul
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
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

Reply via email to