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
