Once a week, the site will have a contest that viewers can enter their guess about the age and score of a buck from a hunting show.? Before saving the entry, we check to see if there is already an entry for the submitted email address.
## Deliverables
The following values should be collected by the form and saved to the database:
name(varchar)
email address(varchar, should be validated)
phone(varchar)
age 1-8 (select drop down)
score 140-400 (select drop down)
table should also store a timestamp of when the entry was submitted.
Before saving the entry, query should run to check if entry for this week has already beden submitted for this week.? Show airs on Thursday, so entries should be validated for prior entry from 5pm thursday until 5pm thursday a week later.? This should work automatically from week to week.
Queries should be contained in qry cfc.? Queries should be in coldfusion templates with cfqueryparam rather than stored procedures.