Ivan Latunov ([EMAIL PROTECTED]) wrote a great UDF for doing that with an
array, called ArrayShuffle (http://www.cflib.org/udf.cfm?ID=292). You
write the companys into an array, and then it shuffles them. (I did a
similar thing here
(http://hscwebdev.unm.edu/webdev/staff/groth/hogwash_form.cfm) to
juggle 25 table cells.
David Groth, Analyst/Programmer III
HSC Library & Informatics Center, University of New Mexico
505.272.8406 e-mail: [EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 04/03/03 03:05PM >>>
Dear CF'ers:
I have searched my CF books for a clue, but am unable to find an
example of
what I am trying to do.
I need to modify the below query so that my results are still ordered
by
"ClassOfService" (a number between 1 and 4) - BUT, the "CompanyName"
needs
to be displayed in a RANDOM ORDER each time the query is run, rather
than
its current alphabetical order. This will give all companies that
participate an even advantage of being selected rather than those that
begin with the first letters of the alphabet.
Can someone please point me in the right direction? I have studied the
CF
RANDOM tag but can't figure out how to apply it.
<CFQUERY NAME="GetAllCompaniesWithMiniSites" DATASOURCE="MedMallDs"
DBTYPE="ODBC">
SELECT *
FROM CompanyTbl
WHERE CompanyWantsMiniSite = 'Yes' AND MakeMiniSitePublic =
'Yes'
ORDER BY CompanyTbl.ClassOfService, CompanyTbl.CompanyName
</CFQUERY>
Thanks very much!!
Tom Forbes
***********************************************************************
Tom Forbes, Forbes Consulting, Inc.
TEL: 407-772-3427 FAX: 407-772-3428
Visit www.medmatrix.com for Medical Equipment Web Sites!
E-Mail Subscription at www.medmatrix.com/mail_list.htm
***********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
