Index: openacs-4/packages/assessment/www/session.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/session.xql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/assessment/www/session.xql	27 Oct 2004 13:51:10 -0000	1.9
+++ openacs-4/packages/assessment/www/session.xql	3 Nov 2004 14:51:52 -0000	1.10
@@ -4,11 +4,11 @@
 
 	<fullquery name="query_all_items">
 		<querytext>
-			SELECT as_itemsx.as_item_id, as_itemsx.name, as_itemsx.title, as_itemsx.feedback_right, as_itemsx.feedback_wrong
+			SELECT as_itemsx.as_item_id, as_itemsx.name, as_itemsx.title, as_itemsx.feedback_right, as_itemsx.feedback_wrong, as_sectionsx.section_id, as_sectionsx.title as section_title, as_sectionsx.description as section_description
 			FROM ((as_sectionsx INNER JOIN (as_assessmentsx INNER JOIN as_assessment_section_map ON as_assessmentsx.assessment_id=as_assessment_section_map.assessment_id) ON
 			as_sectionsx.section_id=as_assessment_section_map.section_id) INNER JOIN (as_itemsx INNER JOIN as_item_section_map ON as_itemsx.as_item_id=as_item_section_map.as_item_id) ON as_sectionsx.section_id=as_item_section_map.section_id) INNER JOIN as_sessionsx ON as_assessmentsx.assessment_id = as_sessionsx.assessment_id
 			WHERE as_sessionsx.session_id = :session_id
-			ORDER BY as_item_section_map.sort_order
+			ORDER BY as_sectionsx.section_id, as_item_section_map.sort_order
 		</querytext>
 	</fullquery>