Skip to main content
Tams87
Participating Frequently
Jul 21, 2008 4:29 PM UTC
Question

Creating a Lottery Application

Hi all,
I am trying to create a lottery application using coldfusion and oracle but so far have had no luck. Has anyone developed such an application and if so could you please direct me in the right direction. The primary purpose of the Lottery is to select all applicants from a table then randomly select a few winners from all applicants based on the number of prizes available.

Your help will be greatly appreciated.

Thank you

2 replies

Celestial_Echo6173
Participant
Nov 13, 2026 1:45 PM UTC

Fetch all eligible applicants from Oracle and use a random selection algorithm to pick winners based on the available prizes. Prevent duplicate selections and keep draw records for transparency. Historical lottery records are also useful for reviewing past outcomes. The tonight greece powerball results history provides a convenient reference for checking previous winning numbers and draw history.

Translate
Dan_Bracuk
Inspiring
Jul 21, 2008 5:08 PM UTC
My approach would be:

Select the count from the table, not all the records. I'm not sure, but you might have to add 1 to this number to make the last record eligible.

Use randrange to get your random numbers.

Select the records where the row number corresponds to those numbers. If you google "oracle row number" you should find the necessary sql.
Translate
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices