Dean Try this
<cfoutput>#queryName.ColumnName[RandRange(1,queryName.RecordCount)]#</cfoutp ut> Or if you have a number of columns to display <cfset row = RandRange(1,queryName.RecordCount)> <cfoutput>#queryName.ColumnName[row]#</cfoutput> <cfoutput>#queryName.ColumnName[row]#</cfoutput> <cfoutput>#queryName.ColumnName[row]#</cfoutput> <cfoutput>#queryName.ColumnName[row]#</cfoutput> Regards Steve Onnis Domain Concept Designs +61 422 337 685 +61 3 9444 7504 http://www.domainconceptdesigns.com <http://www.domainconceptdesigns.com> ("If you think it can't be done, you haven't asked me!") - Steve Onnis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dean Brandt Sent: Monday, February 10, 2003 7:16 PM To: CFAussie Mailing List 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/
