Index: openacs-4/contrib/packages/project-manager/tcl/project-manager-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/tcl/Attic/project-manager-procs-postgresql.xql,v
diff -u -N -r1.2.2.2 -r1.2.2.3
--- openacs-4/contrib/packages/project-manager/tcl/project-manager-procs-postgresql.xql	26 Oct 2004 01:22:27 -0000	1.2.2.2
+++ openacs-4/contrib/packages/project-manager/tcl/project-manager-procs-postgresql.xql	17 Dec 2004 23:06:26 -0000	1.2.2.3
@@ -38,7 +38,7 @@
 
   <fullquery name="pm::util::subsite_assignees_list_of_lists_not_cached.get_assignees">
     <querytext>
-      SELECT
+      SELECT DISTINCT
       p.first_names || ' ' || p.last_name as name,
       p.person_id
       FROM
@@ -50,8 +50,7 @@
       mr.rel_id = r.rel_id and
       p.person_id = r.object_id_two and
       member_state = 'approved'
-      ORDER BY
-      p.first_names, p.last_name
+      ORDER BY name
     </querytext>
   </fullquery>
   
Index: openacs-4/contrib/packages/project-manager/www/project-assign-edit.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/project-assign-edit.tcl,v
diff -u -N -r1.3.2.1 -r1.3.2.2
--- openacs-4/contrib/packages/project-manager/www/project-assign-edit.tcl	2 Jul 2004 23:13:49 -0000	1.3.2.1
+++ openacs-4/contrib/packages/project-manager/www/project-assign-edit.tcl	17 Dec 2004 23:07:30 -0000	1.3.2.2
@@ -1,4 +1,4 @@
-# 
+#
 
 ad_page_contract {
     
@@ -37,7 +37,7 @@
 
 set roles_list_of_lists [pm::role::select_list_filter]
 
-db_foreach assignee_query { 
+db_foreach assignee_query {
     SELECT
     a.party_id,
     r.role_id
@@ -59,7 +59,7 @@
 }
 
 set assignee_list_of_lists [db_list_of_lists get_assignees {
-    select
+    select distinct
     p.first_names || ' ' || p.last_name as name,
     p.person_id
     FROM
@@ -71,8 +71,7 @@
     mr.rel_id = r.rel_id and
     p.person_id = r.object_id_two and
     member_state = 'approved'
-    ORDER BY
-    p.first_names, p.last_name
+    ORDER BY name
 }]