Index: openacs-4/packages/assessment/www/session.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/session.adp,v
diff -u -r1.27.2.5 -r1.27.2.6
--- openacs-4/packages/assessment/www/session.adp	21 Feb 2006 18:09:33 -0000	1.27.2.5
+++ openacs-4/packages/assessment/www/session.adp	25 Feb 2006 15:48:12 -0000	1.27.2.6
@@ -5,7 +5,7 @@
 <table width="100%" cellpadding="3" cellspacing="0" border="0">
 <tr>
 <th colspan="3" align=left>#assessment.Assessment#: <a href="assessment?assessment_id=@assessment_id@">@assessment_data.title@</a></th></tr>
-<tr><td nowrap><b>#assessment.User_ID#:</b> <span><if @show_username_p@><a href="@session_user_url@">@first_names@ @last_name@</a></if><else>#assessment.anonymous_name#</else></span></td>
+<tr><td nowrap><b>#assessment.User_ID#:</b> <span><if @show_username_p@><a href="@session_user_url@">@first_names@ @last_name@</a><if @assessment_data.anonymous_p@ eq "t"><br />#assessment.lt_bNoteb_This_assessmen#</if></if><else>#assessment.anonymous_name#</else></span></td>
 <td nowrap><b>#assessment.Attempt#:</b> <span><a href="sessions?assessment_id=@assessment_id@&subject_id=@subject_id@">@session_attempt@</a><if @assessment_data.number_tries@ not nil> / @assessment_data.number_tries@</if></span></td>
 <td nowrap><if @assessment_data.survey_p@ ne t> <if @showpoints@ eq 1> <b>#assessment.Percent_Score#:</b>  <span>@assessment_score@</span></if></if> </td></tr>
 
Index: openacs-4/packages/assessment/www/asm-admin/results-export.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/asm-admin/results-export.xql,v
diff -u -r1.4.2.1 -r1.4.2.2
--- openacs-4/packages/assessment/www/asm-admin/results-export.xql	21 Feb 2006 18:09:34 -0000	1.4.2.1
+++ openacs-4/packages/assessment/www/asm-admin/results-export.xql	25 Feb 2006 15:48:12 -0000	1.4.2.2
@@ -33,16 +33,26 @@
 
 <fullquery name="all_sessions">
       <querytext> 
+-- 	select s.session_id, s.percent_score, s.subject_id,
+-- 	       to_char(s.completed_datetime, 'YYYY-MM-DD HH24:MI:SS') as submission_date
+-- 	from as_sessions s,
+-- 	     (select max(s2.session_id) as session_id, s2.subject_id
+-- 	      from as_sessions s2, cr_revisions r
+-- 	      where r.item_id = :assessment_id
+-- 	      and s2.assessment_id = r.revision_id
+-- 	      and s2.completed_datetime is not null
+-- 	      group by s2.subject_id) sub
+-- 	where s.session_id = sub.session_id
+-- 	$start_date_sql
+-- 	$end_date_sql
+-- 	order by s.session_id
+
 	select s.session_id, s.percent_score, s.subject_id,
 	       to_char(s.completed_datetime, 'YYYY-MM-DD HH24:MI:SS') as submission_date
-	from as_sessions s,
-	     (select max(s2.session_id) as session_id, s2.subject_id
-	      from as_sessions s2, cr_revisions r
-	      where r.item_id = :assessment_id
-	      and s2.assessment_id = r.revision_id
-	      and s2.completed_datetime is not null
-	      group by s2.subject_id) sub
-	where s.session_id = sub.session_id
+	from as_sessions s, cr_revisions r
+	where r.item_id = :assessment_id
+	and s.assessment_id = r.revision_id
+	and s.completed_datetime is not null
 	$start_date_sql
 	$end_date_sql
 	order by s.session_id