Hi Matthew, > Is there any quick way to jump to a random row in a query ?
If you have the whole query object then you can Do something like this.. (it assumes you will Always return a recordCOunt gte 1).. <cfset thisRand = RandRange(1,myQuery.recordCount)> #myQuery.thisField[thisRand]# #myQuery.thatField[thisRand]# Maybe you could do it at the DB? Cheers, Adam --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
