Thanks Guys. 

My solution worked, is simple, however ugly:

 <cfset answers = "1:2:3:4:5:6">
<cfset request.qry = ListGetAt("#variables.answers#",randrange(1,6),":")>

<cfswitch expression = "#request.qry#">

   -Below this, I have six cases each with a simple query that has a different 
ORDER BY

Thanks for the suggestions. 

Jeff 



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301307
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to