Index: openacs-4/packages/assessment/www/assessment-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/Attic/assessment-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/assessment/www/assessment-oracle.xql	10 Dec 2004 20:23:00 -0000	1.2
+++ openacs-4/packages/assessment/www/assessment-oracle.xql	22 Dec 2004 20:52:17 -0000	1.3
@@ -7,7 +7,7 @@
 			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_id
+			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
@@ -20,7 +20,7 @@
 		<querytext>
     UPDATE as_sessions
     SET creation_datetime = sysdate
-    WHERE session_id = :as_session_id
+    WHERE session_id = :session_id
 		</querytext>
 	</fullquery>