Index: openacs-4/packages/assessment/tcl/as-assessment-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/tcl/as-assessment-procs-oracle.xql,v
diff -u -r1.8.2.1 -r1.8.2.2
--- openacs-4/packages/assessment/tcl/as-assessment-procs-oracle.xql	6 Mar 2006 20:51:07 -0000	1.8.2.1
+++ openacs-4/packages/assessment/tcl/as-assessment-procs-oracle.xql	2 May 2006 12:53:09 -0000	1.8.2.2
@@ -59,4 +59,16 @@
 	</querytext>
 </fullquery>
 	
+<fullquery name="as::assessment::calculate.sum_of_section_points">
+	<querytext>
+
+	select nvl(sum(m.points), 0) as section_max_points, nvl(sum(d.points), 0) as section_points
+	from as_assessment_section_map m, as_section_data d
+	where m.assessment_id = :assessment_id
+	and m.section_id = d.section_id
+	and d.session_id = :session_id
+
+	</querytext>
+</fullquery>
+
 </queryset>
Index: openacs-4/packages/assessment/tcl/as-assessment-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/tcl/as-assessment-procs-postgresql.xql,v
diff -u -r1.8.2.2 -r1.8.2.3
--- openacs-4/packages/assessment/tcl/as-assessment-procs-postgresql.xql	6 Mar 2006 20:51:07 -0000	1.8.2.2
+++ openacs-4/packages/assessment/tcl/as-assessment-procs-postgresql.xql	2 May 2006 12:53:09 -0000	1.8.2.3
@@ -59,4 +59,16 @@
 	</querytext>
 </fullquery>
 	
+<fullquery name="as::assessment::calculate.sum_of_section_points">
+	<querytext>
+
+	select coalesce(sum(m.points), 0) as section_max_points, coalesce(sum(d.points), 0) as section_points
+	from as_assessment_section_map m, as_section_data d
+	where m.assessment_id = :assessment_id
+	and m.section_id = d.section_id
+	and d.session_id = :session_id
+
+	</querytext>
+</fullquery>
+	
 </queryset>
Index: openacs-4/packages/assessment/tcl/as-assessment-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/tcl/as-assessment-procs.xql,v
diff -u -r1.9.2.2 -r1.9.2.3
--- openacs-4/packages/assessment/tcl/as-assessment-procs.xql	3 Mar 2006 13:52:09 -0000	1.9.2.2
+++ openacs-4/packages/assessment/tcl/as-assessment-procs.xql	2 May 2006 12:53:09 -0000	1.9.2.3
@@ -76,18 +76,6 @@
 	</querytext>
 </fullquery>
 	
-<fullquery name="as::assessment::calculate.sum_of_section_points">
-	<querytext>
-
-	select sum(m.points) as section_max_points, sum(d.points) as section_points
-	from as_assessment_section_map m, as_section_data d
-	where m.assessment_id = :assessment_id
-	and m.section_id = d.section_id
-	and d.session_id = :session_id
-
-	</querytext>
-</fullquery>
-	
 <fullquery name="as::assessment::calculate.update_assessment_percent">
 	<querytext>