I have version 4.5 Tom
At 03:09 PM 4/3/03 -0700, you wrote: >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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
