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 -r1.1.2.2 -r1.1.2.3
--- openacs-4/packages/assessment/lib/session-oracle.xql	24 Jul 2007 08:23:16 -0000	1.1.2.2
+++ openacs-4/packages/assessment/lib/session-oracle.xql	25 Jul 2007 11:21:19 -0000	1.1.2.3
@@ -15,16 +15,16 @@
 
 <fullquery name="get_latest_session">
      <querytext>
-	select max(o.creation_date), s.session_id 
+	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
-	and rownum=1
-	group by assessment_id, subject_id, session_id
+	group by assessment_id, subject_id, session_id)
+	where rownum=1
     </querytext>
 </fullquery>