Sure. Generate a random number in CF and run a SWITCH/CASE to determine
which table column to order by.
Courtney E. Payne, Developer
Fig Leaf Software
"We've got you covered"
[EMAIL PROTECTED]
www.figleaf.com
-----Original Message-----
From: Craig M. Rosenblum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 3:24 PM
To: CF-Talk
Subject: Order By Random?
Is there any way to have a query give the results in random order?
This is for Oracle...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
