Index: openacs-4/packages/assessment/www/assessment.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/assessment.tcl,v diff -u -N -r1.49 -r1.50 --- openacs-4/packages/assessment/www/assessment.tcl 6 Feb 2006 20:08:30 -0000 1.49 +++ openacs-4/packages/assessment/www/assessment.tcl 7 Feb 2006 10:44:57 -0000 1.50 @@ -49,7 +49,7 @@ set assessment_rev_id $assessment_data(assessment_rev_id) set number_tries $assessment_data(number_tries) db_1row total_tries {} -if {![empty_string_p $number_tries] && $number_tries >= $total_tries} { +if {![empty_string_p $number_tries] && $number_tries <= $total_tries} { ad_returnredirect [export_vars -base sessions {assessment_id}] } set errors [as::assessment::check_session_conditions -assessment_id $assessment_rev_id -subject_id $user_id -password $password] Index: openacs-4/packages/assessment/www/assessment.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/assessment.xql,v diff -u -N -r1.15 -r1.16 --- openacs-4/packages/assessment/www/assessment.xql 6 Feb 2006 20:08:30 -0000 1.15 +++ openacs-4/packages/assessment/www/assessment.xql 7 Feb 2006 10:44:57 -0000 1.16 @@ -93,12 +93,10 @@ select count(*) as total_tries, max(session_id) as last_session_id - from as_sessions s, cr_revisions r, cr_revisions r2 + from as_sessions s where s.subject_id = :user_id and s.completed_datetime is not null - and s.assessment_id = r.revision_id - and r.item_id = r2.item_id - and r2.revision_id = :assessment_id + and s.assessment_id = :assessment_rev_id