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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
