When assigning judges to review poems, can I use this table to hold the data of
which judges review which poems and the rates they give the poems?
Right now, the form simply lists judges 1-3:
<form
action="#cgi.SCRIPT_NAME#"
method="post"
enctype="multipart/form-data">
<!--- Our form submission flag. --->
<input type="hidden" name="submitted" value="1" />
<input type="hidden" value="#poemid#" />
<label class="block" for=""><input name="Judge 1" id="userid1"
checked="checked" type="checkbox">Judge 1</label>
<label class="block" for=""><input name="Judge 2" id="userid2"
type="checkbox">Judge 2</label>
<label class="block" for=""><input name="Judge 3" id="userid3"
type="checkbox">Judge 3</label>
<div align="center">
<input class="dlgButton" value="Done" type="submit">
</div>
</form>
Since there are only 3 judges, it seems like hardcoding the names wouldn't be
too bad.
When the forms submits, I use:
<cfquery name="updateJudge" datasource="#request.dsn#">
INSERT INTO PoetryJudges (poemID, judge)
VALUES (#form.poemid#, '#form.judge1#')
WHERE ID = #form.poemid#
</cfquery>
How would I handle the event where more than one judge is assigned a poem?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5211
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
