I'll want to total the number of correct answers for each row. I'll also need to group the scores based on class and grade.
The columns in the response table look like: id,student_id,grade,teacherId,response_1,response_2,response_3,...etc This will compare to the answer table: id,survey_id,answer_1,answer_2,answer_3,...etc Thanks in advance, jahlen > >Free Website Trade Publication >> Website Magazine >http://www.websitemagazine.com/referrals/?id=51344&f=text2 >Don't forget to answer the survey questions, it's a 10 second task , >a very small request for access to this incredible resource. > > > >::-----Original Message----- >:: >::Sent: Saturday, September 06, 2008 8:28 AM >::To: CF-Newbie >::Subject: Query question >:: >::Hello All, >:: >::Problem: >:: >::One table contains the responses to a 15 item quiz in numeric columns. >::Another table contains the correct answers to the 15 item quiz in numeric >::columns. I need to be able to evaluate the one table against the other >::and output the results in various forms. >:: >::What would be the best starting point for this? >:: >::I know this is a very open-ended question and I apologize in advance if >::it's too vague. But I think if I can just get an initial idea, I should >::be able to get it done. >:: >::Thanks in advance, >:: >::jahlen >:: >:: >:: >:: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3959 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
