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

[Taco Fleur]

Title: Message

SELECT     TOP 1 yourColumn
FROM         yourTable
ORDER BY NEWID()

 

If you have MS SQL

Taco Fleur
07 3535 5072
Blog: http://www.tacofleur.com/index/blog/
Methodology: http://www.tacofleur.com/index/methodology/
Tell me and I will forget
Show me and I will remember
Teach me and I will learn

-----Original Message-----
From: Matthew Kernick [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 4 February 2004 12: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