This will generally order them according to the clustered index or the order in which they were added. Either way, it's not random. I would expect to see the same results every time.
Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -----Original Message----- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 5:12 PM To: CF-Talk Subject: Re: How can I "ORDER BY RANDOM" ? Remove the CompanyName field from the ORDER BY clause. Then the results will be ordered by ClassOfService only....unless I'm missing your point ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Tom Forbes" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 03, 2003 2:05 PM Subject: How can I "ORDER BY RANDOM" ? > 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
