Index: openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-one-postgresql.xql,v diff -u -r1.25 -r1.26 --- openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql 10 Jun 2004 20:38:29 -0000 1.25 +++ openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql 11 Jun 2004 20:58:19 -0000 1.26 @@ -85,15 +85,15 @@ select r.one_line, - u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as user_info, + u.first_names || ' ' || u.last_name as user_info, r.role_id from pm_task_assignment a, - acs_users_all u, + persons u, pm_roles r where a.task_id = :task_id and - u.party_id = a.party_id and + u.person_id = a.party_id and a.role_id = r.role_id