> Just selecte top 20 like russ said and order by rand() instead of newId()
Correct me if I'm wrong, by all means, but selecting the "top 20" from 10,000 records is about as far from "random" as you can be, isn't it? Won't you have to: 1. randomly select a record with some kind of rand() function of your choosing. (either your SQL or CF) 2. check to ensure that you haven't already selected that record 3. if duplicate entry, go back to 1 4. repeat until 20 records are selected 5. stop I mean, it's a little more complicated to *really* randomly select 20 records from 10,000, but it's certainly not hard with some kind of iteration over that process, right? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274311 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
