If you've got access to mySQL then just ORDER BY RAND(). <!----------------//------ andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//--------->
-----Original Message----- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 11, 2006 3:01 PM To: CF-Talk Subject: Re: Group - but with no order specified It may well be that they don't "not care". They may be specifically asking that they not be in any sort of discernible order. Why are you using the group in the cfoutput instead of in the query? --Ferg Joe Rinehart wrote: >> If I add a ORDER to the query, it obviously works - but, the client >> doesn't WANT them in any order. He just wants the groups together. >> > > I'm not trying to sound like a wiseass, but just point out a > perspective: if the client doesn't care what order they're in, what's > the harm in ordering them? > > If that doesn't satisfy them, maybe try an ORDER BY on the primary key > of whatever's giving you myGroup. > > -Joe > > -- > Get Glued! > The Model-Glue ColdFusion Framework > http://www.model-glue.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237463 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
