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.5 -r1.6
--- openacs-4/packages/assessment/tcl/as-section-procs.xql	26 Dec 2004 15:07:44 -0000	1.5
+++ openacs-4/packages/assessment/tcl/as-section-procs.xql	7 Jan 2005 16:10:44 -0000	1.6
@@ -16,7 +16,7 @@
 
 	select cr.item_id as section_item_id, cr.title, cr.description,
 	       s.instructions, s.feedback_text, s.max_time_to_complete,
-	       s.display_type_id, s.points
+	       s.display_type_id, s.points, s.num_items
 	from cr_revisions cr, as_sections s
 	where cr.revision_id = :section_id
 	and s.section_id = cr.revision_id
@@ -29,7 +29,7 @@
 
 	select cr.title, cr.description,
 	       s.instructions, s.feedback_text, s.max_time_to_complete,
-	       s.display_type_id, s.points
+	       s.display_type_id, s.points, s.num_items
 	from cr_revisions cr, as_sections s
 	where cr.revision_id = :section_id
 	and s.section_id = cr.revision_id
@@ -49,40 +49,6 @@
       </querytext>
 </fullquery>
 
-<fullquery name="as::section::items.get_sorted_items">
-	<querytext>
-
-	select s.as_item_id, ci.name, r.title, r.description, i.subtext, m.required_p,
-	       m.max_time_to_complete
-	from as_session_items s, as_items i, as_item_section_map m, cr_revisions r,
-	     cr_items ci
-	where s.session_id = :session_id
-	and s.section_id = :section_id
-	and i.as_item_id = s.as_item_id
-	and r.revision_id = i.as_item_id
-	and ci.item_id = r.item_id
-	and m.as_item_id = s.as_item_id
-	and m.section_id = s.section_id
-	order by s.sort_order
-
-	</querytext>
-</fullquery>
-	
-<fullquery name="as::section::items.section_items">
-	<querytext>
-
-	select i.as_item_id, ci.name, cr.title, cr.description, i.subtext,
-	       m.required_p, m.max_time_to_complete, m.fixed_position
-	from as_item_section_map m, as_items i, cr_revisions cr, cr_items ci
-	where cr.revision_id = i.as_item_id
-	and i.as_item_id = m.as_item_id
-	and m.section_id = :section_id
-	and ci.item_id = cr.item_id
-	order by m.sort_order
-
-	</querytext>
-</fullquery>
-	
 <fullquery name="as::section::items.save_order">
 	<querytext>