Index: openacs-4/packages/assessment/www/session.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/session.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/assessment/www/session.xql 21 Sep 2004 15:07:12 -0000 1.3 +++ openacs-4/packages/assessment/www/session.xql 23 Sep 2004 14:20:56 -0000 1.4 @@ -4,7 +4,7 @@ - SELECT as_itemsx.as_item_id, as_itemsx.name, as_itemsx.title + SELECT as_itemsx.as_item_id, as_itemsx.name, as_itemsx.title, as_item_section_map.feedback_text FROM ((as_sectionsx INNER JOIN (as_assessmentsx INNER JOIN as_assessment_section_map ON as_assessmentsx.assessment_id=as_assessment_section_map.assessment_id) ON as_sectionsx.section_id=as_assessment_section_map.section_id) INNER JOIN (as_itemsx INNER JOIN as_item_section_map ON as_itemsx.as_item_id=as_item_section_map.as_item_id) ON as_sectionsx.section_id=as_item_section_map.section_id) INNER JOIN as_sessionsx ON as_assessmentsx.assessment_id = as_sessionsx.assessment_id WHERE as_sessionsx.session_id = :session_id @@ -15,7 +15,7 @@ SELECT - as_item_choicesx.choice_id, as_item_choicesx.title AS choice_title, as_item_choicesx.correct_answer_p, as_item_datax.choice_id_answer + as_item_choicesx.choice_id, as_item_choicesx.title AS choice_title, as_item_choicesx.correct_answer_p, as_item_choicesx.percent_score, as_item_datax.choice_id_answer FROM as_item_choicesx LEFT JOIN (as_item_datax INNER JOIN as_sessionsx ON as_sessionsx.session_id = as_item_datax.session_id) ON as_item_datax.choice_id_answer=as_item_choicesx.choice_id WHERE as_item_choicesx.mc_id=:mc_id