Index: openacs-4/packages/evaluation/www/admin/evaluations/student-list.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/evaluations/student-list.xql,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/evaluation/www/admin/evaluations/student-list.xql	24 Aug 2004 22:40:32 -0000	1.8
+++ openacs-4/packages/evaluation/www/admin/evaluations/student-list.xql	10 Sep 2004 19:16:31 -0000	1.9
@@ -27,13 +27,13 @@
       </querytext>
 </fullquery>
 
-<partialquery name="not_yet_in_clause">
+<partialquery name="not_yet_in_clause_non_empty">
 	  <querytext>         
 		where p.person_id not in ([join $done_students ","])
 	  </querytext>
 </partialquery>
 
-<partialquery name="not_yet_in_clause">
+<partialquery name="not_yet_in_clause_empty">
 	  <querytext>         
  
       , cc_users cu 
@@ -68,16 +68,18 @@
 
 <partialquery name="sql_query_individual">
 	  <querytext>         
+
 		select p.person_id as party_id,
 		p.last_name||', '||p.first_names as party_name
 		from persons p 
 		$not_in_clause
-		$orderby_na
+
 	  </querytext>
 </partialquery>
 
 <partialquery name="sql_query_community_individual">
 	  <querytext>         
+
             select app.user_id as party_id,
   		   p.last_name||', '||p.first_names as party_name
             from dotlrn_member_rels_approved app,
@@ -86,14 +88,15 @@
 	      and app.community_id = :community_id
 	      and app.user_id = p.person_id
 	      and app.role = 'student'
-	      $orderby_na
+
 	  </querytext>
 </partialquery>
 
 <fullquery name="get_not_evaluated_na_students">      
       <querytext>
 
 		$sql_query
+		$orderby_na
 	
       </querytext>
 </fullquery>