Re: Random record?

[jcollet2]

Try this.

<cfquery name=getRecords DS=Blah>
     SELECT UserID FROM tblUsers
</cfquery>

<cfset randNum = RandRange(1, getRecords.RecordCount)>


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/fusebox@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists