Once upon a time when I ran CF ver. 5 and 6, this code worked
<CFQUERY Name="GetBlogUser" Datasource="#session.DSN1#"
ORDER BY rnd(BlogAuthor)
I'd get a random row returned every time. Life was good.
Once I moved to CF 7 it no longer worked. It instead returned
the very same row each time. A cache problem they would tell me so
I'd empty the cache and sure enough the next time it actually would
be a different order. Next time however it was stuck on the new
Recently I have moved to a new server and upgraded my
miserable Access table to MySQL. Now, that same code gives me the