Random selection

[Jake McKee]

I need some help on a random image issue.   I’m currently trying to pull 4 distinct random images from the images table. Code for that is below. It works like a champ, minus that distinct requirement. Any ideas?   Thanks! Jake   ========= <cfquery name="findRandom" datasource="#application.datasource#">                         SELECT DISTINCT PhotoID                         FROM Photos                         WHERE photoStatus = 1 </cfquery>   <CFSET List = #ValueList(findRandom.photoID)# >   <CFLOOP from="1" to="4" index="i">   <cfset current_image = RandRange(1, findRandom.recordCount)> <cfset position=ListGetAt(list, current_image)>               <cfquery name="findRandom2" datasource="#application.datasource#">                         SELECT DISTINCT thumbName, photoID                         FROM Photos                         WHERE photoStatus = 1                         AND PhotoID = #position#             </cfquery>                         <CFOUTPUT query="findRandom2">                         <a href="">Test Link</a>             </CFOUTPUT>             </CFLOOP>