Index: openacs-4/packages/assessment/tcl/as-qti-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/tcl/as-qti-procs.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/assessment/tcl/as-qti-procs.xql 14 Feb 2005 08:43:14 -0000 1.3 +++ openacs-4/packages/assessment/tcl/as-qti-procs.xql 18 Feb 2005 15:51:07 -0000 1.4 @@ -4,38 +4,30 @@ INSERT INTO as_assessment_section_map (assessment_id, section_id, max_time_to_complete, sort_order, points) - VALUES (:as_assessments__assessment_id, :as_sections__section_id, :as_sections__duration, :as_assessment_section_map__sort_order, :as_sections__points) + VALUES (:as_assessments__assessment_id, :section_id, :as_sections__duration, :as_assessment_section_map__sort_order, :as_sections__points) - + - INSERT INTO as_item_section_map (as_item_id, section_id, max_time_to_complete, sort_order, points) - VALUES (:as_item_id, :section_id, :as_items__duration, :as_item_section_map__sort_order, :as_items__points) - - - - - - update as_sections - set display_type_id = :display_id - where section_id = :as_sections__section_id + INSERT INTO as_item_section_map (as_item_id, section_id, sort_order) + VALUES (:as_item_id, :section_id, :as_item_section_map__sort_order) select sum(aism.points) as as_sections__points from as_item_section_map aism, as_assessment_section_map aasm - where aism.section_id = aasm.section_id and aasm.section_id = :as_sections__section_id + where aism.section_id = aasm.section_id and aasm.section_id = :section_id update as_assessment_section_map set points = :as_sections__points - where section_id = :as_sections__section_id + where section_id = :section_id