Once you've used your cfquery - in a loop run some code that will select 2 randaom rows and swap the values... just a quick thought... never tested it out... you should be able to swap the rows like this: query_name.column_01[row number], you'd have to swap every column individually though... Which brings a question to mind. Does anyone know the syntax for swaping an entire row? is there any such syntax? > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 22 May 2001 14:46 > To: CF-Talk > Subject: Randomizing a Query Result or List > > > I do a complex query and currently the results are returned > based on the > order they appear in the db. What I need to do is have the > order they are > returned as random. > > Is there a ORDER BY RANDOM type of syntax that will work with > my Access > database? > > Alternatively, the results are stored in a list (ex: > 5,8,3,7,89,100,305,306) > Anyone know how to take an existing List and mix it all up? > > Thanks, > > Brian > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

