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

Reply via email to