[thelist] CF - Random Rows?

[Frank]

I'm trying to create the situation whereby I can access a random 
record from the lot. I had originally used max and min, but if a 
record is deleted from the set, and the random number turns out to be 
the ID of the deleted record, there's a problem.

Now, as I've got it set up (see below) I'm getting that there are too 
few parameters. Why isn't Int(GetExisting.ID) seen as a legitimate 
int? Does anyone know the work around?



<!--- Choose all existing records --->
<cfquery name="GetExisting" datasource="#datasource#">
   SELECT ID
    FROM Address
</cfquery>


<!--- Select a random property from the existing records--->
<cfquery name="GetRand" datasource="#datasource#">
    SELECT MAX(Int(GetExisting.ID)) as MaxProp,
           MIN(Int(GetExisting.ID)) as MinProp
    FROM Address
</cfquery>



<cfoutput query="GetRand">
    #RandRange(MinProp, MaxProp)#
</cfoutput>
-- 


Frank Marion                      Loofah Communications
frank at loofahcom.com               http://www.loofahcom.com