One way: <cfset variables.rannum = randrange(1, qryName.recordcount)> <cfset variables.ranrecord = qryName.columnName[variables.rannum]>
HTH J ----- Original Message ----- From: "Eric J Hoffman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 5:19 PM Subject: Random Record > What is the best way to get a random record from an table that has > frequent changes and updates...best practices or practical advice from > veterans? Randrange between 1 and recordcount won't work pulling a num > and then going against primary id..so somehow to get a "row"? > > Thanks. > > Regards, > > Eric J. Hoffman > Director of Internet Development > DataStream Connexion, LLC > (formerly Small Dog Design) > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
