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.2 -r1.3 --- openacs-4/packages/assessment/lib/session-oracle.xql 15 May 2007 20:14:16 -0000 1.2 +++ openacs-4/packages/assessment/lib/session-oracle.xql 7 Oct 2007 22:36:53 -0000 1.3 @@ -15,16 +15,16 @@ - 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 - group by assessment_id, subject_id, session_id - limit 1 + group by assessment_id, subject_id, session_id) + where rownum=1