As a thought experiment (at least), you could eliminate repeats using CF as follows:
Download http://cflib.org/udf/ListRandomElements and then do this: <cfset thelist = ""> <cfloop index="i" from="1" to="#rs.recordcount#"> <cfset thelist = listappend(thelist, i)> </cfloop> <cfloop list="#ListRandomElements(thelist, rows)#" index="displayRow"> <br /><h3>#displayRow# #rs.first[displayRow]# #rs.last[displayRow]# #rs.flag[displayRow]#</h3><br /> </cfloop> On Mon, Jan 14, 2013 at 10:59 AM, B Griffith <[email protected]> wrote: > > Thank you all, I used CF first per the first response and got repeats > among the iterations and then tried the SQL version using "TOP X" and > newid() and was able to make that work with no repeats! Also, thanks to > everyone for your speedy responses and friendliness, I've had experiences > with other forums that were terrible so it was a relief to find these > forums for CF. I'll be sure to post with my next issue which is likely to > be creating a secure login, unless there is already a thread on that here > that someone might point me to? > > Great advice, keep it up folks. :) > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353857 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
