Hello Everyone,
Is there a way to sort a column in random order? I thought something like:
SELECT * FROM MyTable
WHERE
MyVariable='#myvalue#'
ORDER BY RANDOM
would output something like
1
2
3 the first time
and then
1
3
2 (varying in order)
but all it does is say error... If there isn't a way built into cf/sql to do this does
someone have their own method that they'd be willing to share?
Thanks,
Tony Hicks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
