[cfaussie] RE: Jumping to a row in a query

[Steve Onnis]

Title: Message

#query.column[RandRange(1,query.recordCount)]#

 

That should do it for you

 

basically you can reference the rows by their index, and what I am doing is getting a random number between 1 and the total records and using that as its index

 

Steve

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Matthew Kernick
Sent: Wednesday, February 04, 2004 1:22 PM
To: CFAussie Mailing List
Subject: [cfaussie] Jumping to a row in a query

Hi all,

 

Is there any quick way to jump to a random row in a query ?

 

have a series of records of which I want to randomly display 1 on the page.

 

Thanks

 

Matthew Kernick
Development Team Leader
Director
eNTITy1 Pty Ltd - "The e-Business Specialists"
Switch PH: (08) 89411 162
Direct PH: (08) 89468 271
Fax: (08) 89411 167
email: [EMAIL PROTECTED]
website: http://www.entity1.com

 

---
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

---
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