To all- thanks for all your responses. Shucks, Neil; but of course, the most obvious answers is always just a google away.
> -----Original Message----- > From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson- > [EMAIL PROTECTED] > Sent: Thursday, March 22, 2007 12:13 AM > To: CF-Talk > Subject: Re: How to Random Pick records from a 10k record table via SQL > > By taking 2 seconds to use Google > > http://www.google.co.uk/search?hl=en&q=select+random+rows+%2B+SQL&btnG=Goo > gl > e+Search&meta= > > > > > > "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, > Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, > Registered in England, Number 678540. It contains information which is > confidential and may also be privileged. It is for the exclusive use of > the > intended recipient(s). If you are not the intended recipient(s) please > note > that any form of distribution, copying or use of this communication or the > information in it is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the sender or > call > our switchboard on +44 (0) 20 89107910. The opinions expressed within > this > communication are not necessarily those expressed by Reed Exhibitions." > Visit our website at http://www.reedexpo.com > > -----Original Message----- > From: srinivas ganta > To: CF-Talk > Sent: Thu Mar 22 07:10:47 2007 > Subject: Re: How to Random Pick records from a 10k record table via SQL > > Hi Michel, > > try the following query,i think this will help you. > select * from myTable order by rand() limit 20; > > Thanks > Srinivas > > On 3/22/07, Michael E. Carluen <[EMAIL PROTECTED]> wrote: > > > > Hello All, > > > > I am wondering how to randomly pick any 20 records from a table of > 10,000+ > > records, directly from a cfquery? Currently using mySQL. > > > > Any suggestions will be appreciated. > > > > Michael > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273347 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
