Use the Rnd() function.
SELECT *
FROM stuff
ORDER BY Rnd(stuff_id)
Jim
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 21, 2001 10:45 PM
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