oracle uses the DBMS_RANDOM package to create random numbers. Kore Peterson Database Development Specialist SEH - Minneapolis 612.758.6739
"David Jones"
<djones@applie To: CF-Talk <[EMAIL PROTECTED]>
dx.com> cc:
Subject: RE: Randomizing Query Results
10/08/2002
08:54 AM
Please respond
to cf-talk
What database does this work on? I should have specified what database I am
using. I am developing for Oracle 8i.
Thanks,
Dave
-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 10:42 AM
To: CF-Talk
Subject: Re: Randomizing Query Results
David Jones wrote:
> What is the best way to randomize the results of a CF query?
Offload it to the database:
SELECT *
FROM table
ORDER BY Random()
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
