61 : <cfset list = valueList(GetAllAgents.rosterID)>
62 : <cfset listlength = listlen(list)>
63 : <cfset RandomAgent = ListGetAt(list,RandRange(1, listlength))>
64 : <CFQUERY NAME="GetAgent" DATASOURCE="REOL_roster">
65 : SELECT firstname,lastname,phone,rosterid,Office_Phone,NRDS FROM agents WHERE Brokerid = #BrokersSiteID# AND rosterID=#RandomAgent#
|