Thanks mike I'll give that a try - but out of interest what does that code really mean ? - ok - so I'm an idiot in sql !
Cheers Richard ----- Original Message ----- From: "Mike Townend" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 27, 2003 1:28 AM Subject: RE: ot - random sql select > If you are using SQLServer 2K (not sure if it works in 7) you could use > > SELECT TOP 10 * > FROM Foo > ORDER BY NewID() > > > HTH > > > > -----Original Message----- > From: admin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 27, 2003 07:11 > To: CF-Talk > Subject: ot - random sql select > > > is there an easy way to select say 10 records at random from an sql table ? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
