Hi Benjamin, Thanks for the good sql resource. I looked at the 7 articles, the ones that pertain to Access are dead links. I have Access DB.
But, this site will come in very handy for other queries. Thanks very much! Tom At 05:33 PM 4/3/03 -0500, you wrote: >A quick search produced this list of articles: > >http://www.sqlteam.com/FilterTopics.asp?TopicID=135 > >Benjamin S. Rogers >http://www.c4.net/ >v.508.240.0051 >f.508.240.0057 > >-----Original Message----- >From: Tom Forbes [mailto:[EMAIL PROTECTED] >Sent: Thursday, April 03, 2003 5:06 PM >To: CF-Talk >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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
