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:353856 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
