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 @@
-
-
-
- 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
-
-
-
-
-
-
-
- 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
-
-
-
-