Randomizing results in queries

[Natesac]

Lets say that I have 24 records in a table... I want to be able to return 1 row only, but randomize which row is returned each time the query is accessed.

Note: I am currently using MX 6.1, so functions available in 7 obviously will not work.

Many thanks in advance.

-Nathan

[Natesac · Accepted solution]

Nevermind... I did a little RandRange on the RecordCount of the query, and then just relooped it to give me a different output on <cfoutput query="myquery" maxrows="1" startrow="#myRandNum#">

I fingered it out.

Thanks for reading, though. 🙂