Hello -
I am attempting to finish an application that allows judges to rate poems. I
collect the poem from the user then have judges login to a secured directory to
review and rate the poem. At this point, I have a table that lists the poem
title and record id. I want to list the average rating from the judges scores
in a third column and list the judges who reviewed the poem in the fourth
column:
ID Title Rating Judge(s)
The poem title is a link that goes to a page listing the full poem and has a
drop down list for the judge to rate the poem 1-5. This response is captured
in a table separate from the poem table.
With all this, I am wondering how to assign judges to poems. Currently, there
are 3 judges to assign to poems. Under the "judges" column, I have pseudocode
manually listing the names and a small "edit" button. Upon clicking the
button, a form appears listing all the judges names with textboxes next to
them. Checking the boxes and clicking done should assign the selected judge(s)
to review the specific poem. I do not know if I should record the assigned
judges in the poem table, the rating table or a third table. Here is the code
I currently have to detail what is going on:
<table id="box-table-a" summary="Cumulative List of Poems">
<thead>
<tr>
<th>ID</th>
<th>Title</th>
<th>Rating</th>
<th>Judge(s)</th>
<th></th>
</tr>
</thead>
<tbody>
<cfoutput query="qGetPoems"
startrow="#pagination.getStartRow()#" maxrows="#pagination.getMaxRows()#">
<tr>
<td class="poemID">#id#</td>
<td><a
href="poemOverview.cfm?id=#id#">#poemTitle#</a></td>
<td>#average#</td>
<td>Judge 1<br />Judge 2<br /> Judge 3 </td>
<td>
<div class="examples">
<input class="pretty_button"
name="toggleh1" value="Edit" id="toggleh1"
onclick="switchMenu('myvar#currentRow#');" type="submit" title="Click to edit
judges"/>
</div>
<div id="myvar#currentRow#"
class="showhide" style="display: none;">
<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="#id#" />
<label class="block"
for=""><input name="" id="" checked="checked" type="checkbox">Judge 1</label>
<label class="block"
for=""><input name="" id="" type="checkbox">Judge 2</label>
<label class="block"
for=""><input name="" id="" type="checkbox">Judge 3</label>
<div
align="center">
<input
class="dlgButton" value="Done" type="submit">
</div>
</form>
</div>
</td>
</tr>
</cfoutput>
<tr>
<td colspan="5"
class="pagination"><cfoutput>#pagination.getRenderedHTML()#</cfoutput></td>
</tr>
</tbody>
</table>
TL;DR - Need to assign judges to review poems. Not sure how to record judges
assigned or where to record them.
Thanks,
Adam
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:5197
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
