I know, I stated in my question that I wanted to MODIFY the EXISTING query.
At 02:26 PM 4/3/03 -0800, you wrote: >OK...but you should still remove that field from the ORDER BY clause :-) >Granted it may not always return records in a random order, but there is no >point in ordering by the CompanyName if you're after random results. > >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:16 PM >Subject: Re: How can I "ORDER BY RANDOM" ? > > > > Bryan, > > > > I need to display the company names in a random order EACH TIME the query > > is run. > > > > Thanks, > > > > Tom > > > > > > At 02:12 PM 4/3/03 -0800, you wrote: > > >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
