I have a Query of Query right now that I'd like to have the results sort order randomized. Any ideas? I've seen examples dependent on the dbms for producing a random randomization, but is there any way to do that within QofQ? The base query that my QoQ is operating on is a cached Oracle query.
Also brainstorming for other alternatives. It's a simple round robin load balancer. I'd rather not have the first unit just by database index order selected all the time. TIA ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327158 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
