Index: openacs-4/packages/assessment/www/admin/one-a.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/admin/Attic/one-a.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/assessment/www/admin/one-a.xql 14 Nov 2004 16:43:21 -0000 1.1 +++ openacs-4/packages/assessment/www/admin/one-a.xql 10 Dec 2004 11:42:23 -0000 1.2 @@ -3,10 +3,11 @@ - select s.section_id, cr.title, s.definition, s.instructions, s.required_p, - s.feedback_text, s.max_time_to_complete, asm.sort_order - from as_sections s, cr_revisions cr, as_assessment_section_map asm - where cr.revision_id = s.section_id + select s.section_id, cr.title, ci.name, s.instructions, s.feedback_text, + asm.max_time_to_complete, asm.sort_order, asm.points, s.display_type_id + from as_sections s, cr_revisions cr, cr_items ci, as_assessment_section_map asm + where ci.item_id = cr.item_id + and cr.revision_id = s.section_id and s.section_id = asm.section_id and asm.assessment_id = :assessment_rev_id order by asm.sort_order