Index: openacs-4/packages/assessment/www/assessment-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/assessment-postgresql.xql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/assessment/www/assessment-postgresql.xql 26 Nov 2004 20:46:51 -0000 1.5 +++ openacs-4/packages/assessment/www/assessment-postgresql.xql 10 Dec 2004 20:21:50 -0000 1.6 @@ -4,7 +4,7 @@ - SELECT i.as_item_id, i.name, i.title, s.section_id as section_id, s.title as section_title, s.description as section_description + SELECT i.as_item_id, i.name, i.title, i.subtext, s.section_id as section_id, s.title as section_title, s.description as section_description FROM as_sectionsx s INNER JOIN as_assessment_section_map asm USING (section_id) INNER JOIN as_assessmentsx a USING (assessment_id) INNER JOIN as_item_section_map ism ON s.section_id = ism.section_id