If you're picking one item from a query, you can just do: myQuery.myColumn[randRange(1, myQuery.recordCount)]
That'll be way more efficient than reordering the whole query. cheers, barneyb On Tue, Oct 13, 2009 at 2:53 PM, Yuliang Ruan <[email protected]> wrote: > > 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:327160 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
