2 Replies Latest reply on Sep 26, 2008 7:32 PM by BrettCPI

    Returning A Random Record

      I want to cfquery a random record from a table. I can't randrange the key field because some keys are not there. I've seen a suggestion to load the keys into a table, grab a random instance, then query with that key but that seems like a long way around to me. There could be thousands of record in this table.

      Any ideas? Thanks!