I'd create a list or array (well, for me, an array) in the loop. Insert
the winners there, checking each time to make sure that the winner you
picked isn't already chosen. Then, loop over the list of winners to do
your inserts.
--Ben
Stuart Kidd wrote:
> Hi guys,
>
> I'm trying to write an app which will choose three random numbers for
> a competition based on how many etnries there are. I'm having
> problems trying to work out a way not to choose the same number
> twice, is there a way to do that which will fit into my CFLOOP
> structure? Or is there a better way to do it?
>
> <cfloop from="1" to="#ShowCompetitions.prizeCount">
>
> <cfset RandomWinner = RandRange(1, FindEntries.RecordCount)>
>
> <cfquery name="competitionWinner" datasource="user020"> INSERT INTO
> tbl_020competitionWinners (competitionID, entryID) VALUES
> ('#FindEntries.competitionID[i]#',
> '#ShowCompetitions.competitionID[i]#') </cfquery>
>
> </cfloop>
>
> Thanks,
>
> Saturday
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227270
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
