<cfoutput query="RandArticle" startrow=#RandRange(1,RandArticle.RecordCount)# maxrows=1>
hope this helps Steve Soars [p] 07 3821-5800 [f] 07 3821-5811 www.i-redlands.com.au Interactive Redlands "what we do in life echoes an eternity" ----- Original Message ----- From: "Dean Brandt" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Monday, February 10, 2003 6:16 PM Subject: [cfaussie] Random Record in a query Hi Guys, I am retrieving a set of records using a query and I want to pick a random record from that query and display it, any pointers on how this is achieved? Thanks Dean Brandt Clever Thinking Consulting Network/Systems Integration, Application Design Melbourne, Australia 0418488885 ...smart networks for smart business --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
