Index: openacs-4/packages/assessment/www/assessment-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/assessment-oracle.xql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/assessment/www/assessment-oracle.xql 7 Jan 2005 16:10:44 -0000 1.4 +++ openacs-4/packages/assessment/www/assessment-oracle.xql 18 Jan 2005 12:42:37 -0000 1.5 @@ -2,20 +2,6 @@ oracle8.1.6 - - - 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, as_assessmentsx a, as_item_section_map ism, - as_itemsx i - WHERE a.assessment_id = :assessment_rev_id - AND s.section_id = asm.section_id - AND asm.assessment_id = a.assessment_id - AND s.section_id = ism.section_id - AND i.as_item_id = ism.as_item_id - ORDER BY s.section_id, ism.sort_order - - - UPDATE as_sessions