Index: openacs-4/packages/assessment/tcl/as-section-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/tcl/as-section-procs.xql,v
diff -u -r1.10 -r1.11
--- openacs-4/packages/assessment/tcl/as-section-procs.xql	23 Jan 2005 18:10:48 -0000	1.10
+++ openacs-4/packages/assessment/tcl/as-section-procs.xql	21 Feb 2005 14:32:56 -0000	1.11
@@ -74,14 +74,18 @@
 <fullquery name="as::section::calculate.sum_of_item_points">
 	<querytext>
 
-	select sum(m.points) as item_max_points, sum(d.points) as item_points
-	from as_item_data d, as_item_section_map m, as_session_item_map sm
+	select sum(m.points) as item_max_points, sum(d.points) as item_points,
+	       max(s.section_data_id) as section_data_id
+	from as_item_data d, as_item_section_map m, as_session_item_map sm,
+	     as_section_data s
 	where m.section_id = :section_id
 	and d.section_id = m.section_id
 	and d.as_item_id = m.as_item_id
 	and d.session_id = :session_id
 	and sm.session_id = d.session_id
 	and sm.item_data_id = d.item_data_id
+	and s.session_id = d.session_id
+	and s.section_id = d.section_id
 
 	</querytext>
 </fullquery>