Index: openacs-4/packages/assessment/www/assessment-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/Attic/assessment-postgresql.xql,v diff -u -r1.8 -r1.9 --- openacs-4/packages/assessment/www/assessment-postgresql.xql 7 Jan 2005 16:10:44 -0000 1.8 +++ openacs-4/packages/assessment/www/assessment-postgresql.xql 18 Jan 2005 12:42:37 -0000 1.9 @@ -2,18 +2,6 @@ postgresql7.4 - - - 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 - INNER JOIN as_itemsx i USING (as_item_id) - WHERE a.assessment_id = :assessment_rev_id - ORDER BY s.section_id, ism.sort_order - - - UPDATE as_sessions