there is a rand function but I have never used it.
-----Original Message-----
From: BT [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 10:47 AM
To: CF-Talk
Subject: Random in SQL
I am trying to get a random 5 items in SQL on SQL7 instead of on the cf
side....
Anyone know?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists