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 -r1.3 -r1.4 --- openacs-4/contrib/packages/project-manager/www/project-assign-edit.tcl 1 Jul 2004 21:40:30 -0000 1.3 +++ openacs-4/contrib/packages/project-manager/www/project-assign-edit.tcl 13 Jan 2005 13:54:36 -0000 1.4 @@ -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 }]