Make a separate table "Judges" and have 3 fields. PoemID, Score, Judge. Use that table to store what each judge selects as their score, then do some factoring. The Poem table should only have the PoemID and Title (and perhaps the actual poem).
<cfquery name="Poems"> Select * from Poems </cfquery> <cfoutput name="Poems"> <cfquery name="Data"> Select SUM(Score) as TotalScore >From Judges Where PoemID = #CurrentPoem.PoemID# </cfquery> #Poems.Title# scored a #Data.TotalScore#.<BR> </cfoutput> On Thu, Jan 13, 2011 at 11:48 AM, Adam Parker <[email protected]> wrote: > > 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> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:5198 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
