Index: openacs-4/packages/assessment/lib/session-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/lib/session-oracle.xql,v
diff -u -N -r1.3 -r1.3.2.1
--- openacs-4/packages/assessment/lib/session-oracle.xql	7 Oct 2007 22:36:53 -0000	1.3
+++ openacs-4/packages/assessment/lib/session-oracle.xql	8 Oct 2008 15:45:22 -0000	1.3.2.1
@@ -13,19 +13,4 @@
       </querytext>
 </fullquery>
 
-<fullquery name="get_latest_session">
-     <querytext>
-	select * from (select max(o.creation_date), s.session_id 
-        from as_sessions s, 
-        acs_objects o,
-        cr_revisions cr
-	where s.subject_id=:user_id
-        and s.assessment_id in (select revision_id from cr_revisions where item_id= :assessment_id)
-	and o.object_id = cr.item_id
-        and s.session_id = cr.revision_id
-	group by assessment_id, subject_id, session_id)
-	where rownum=1
-    </querytext>
-</fullquery>
-
 </queryset>
Index: openacs-4/packages/assessment/lib/session-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/lib/session-postgresql.xql,v
diff -u -N -r1.3 -r1.3.4.1
--- openacs-4/packages/assessment/lib/session-postgresql.xql	21 Nov 2006 15:13:30 -0000	1.3
+++ openacs-4/packages/assessment/lib/session-postgresql.xql	8 Oct 2008 15:45:22 -0000	1.3.4.1
@@ -12,19 +12,4 @@
       </querytext>
 </fullquery>
 
-<fullquery name="get_latest_session">
-     <querytext>
-	select max(o.creation_date), s.session_id 
-        from as_sessions s, 
-        acs_objects o,
-        cr_revisions cr
-	where s.subject_id=:user_id
-        and s.assessment_id in (select revision_id from cr_revisions where item_id= :assessment_id)
-	and o.object_id = cr.item_id
-        and s.session_id = cr.revision_id
-	group by assessment_id, subject_id, session_id
-	limit 1
-    </querytext>
-</fullquery>
-
 </queryset>
Index: openacs-4/packages/assessment/www/session-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/session-oracle.xql,v
diff -u -N -r1.2 -r1.2.8.1
--- openacs-4/packages/assessment/www/session-oracle.xql	24 Feb 2005 09:22:12 -0000	1.2
+++ openacs-4/packages/assessment/www/session-oracle.xql	8 Oct 2008 15:45:22 -0000	1.2.8.1
@@ -12,4 +12,19 @@
       </querytext>
 </fullquery>
 
+  <fullquery name="get_latest_session">
+    <querytext>
+      select * from (select max(o.creation_date), s.session_id 
+        from as_sessions s, 
+        acs_objects o,
+        cr_revisions cr
+      where s.subject_id=:user_id
+        and s.assessment_id in (select revision_id from cr_revisions where item_id= :assessment_id)
+        and o.object_id = cr.item_id
+        and s.session_id = cr.revision_id
+      group by assessment_id, subject_id, session_id)
+      where rownum=1
+    </querytext>
+  </fullquery>
+
 </queryset>
Index: openacs-4/packages/assessment/www/session-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/session-postgresql.xql,v
diff -u -N -r1.1 -r1.1.8.1
--- openacs-4/packages/assessment/www/session-postgresql.xql	21 Feb 2005 14:32:56 -0000	1.1
+++ openacs-4/packages/assessment/www/session-postgresql.xql	8 Oct 2008 15:45:22 -0000	1.1.8.1
@@ -12,4 +12,19 @@
       </querytext>
 </fullquery>
 
+  <fullquery name="get_latest_session">
+    <querytext>
+      select max(o.creation_date), s.session_id 
+        from as_sessions s, 
+        acs_objects o,
+        cr_revisions cr
+      where s.subject_id=:user_id
+        and s.assessment_id in (select revision_id from cr_revisions where item_id= :assessment_id)
+        and o.object_id = cr.item_id
+        and s.session_id = cr.revision_id
+      group by assessment_id, subject_id, session_id
+      limit 1
+    </querytext>
+  </fullquery>
+
 </queryset>