We recently moved an application the uses an Access database from CF5 to
CF8. To display a set of records in random order we had been using a
query like:
SELECT ....,
Rnd(id) AS randcolumn
FROM ...
ORDER BY randcolumn
The values in randcolumn are floats in the range of 0 to 1. This worked
well in CF5, but in CF8 it appears to consistently generate the same sets
of numbers for randcolumn. What's really odd is that about 90+% of the
time it will return the exact same set of numbers (and so the same sort
order), then the remaining 10% of the time there will be a couple other
variations.
Any ideas about what's going on and whether there's a simple workaround?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298141
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
