Index: openacs-4/packages/acs-tcl/tcl/community-core-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/community-core-procs-postgresql.xql,v diff -u -r1.17.2.2 -r1.17.2.3 --- openacs-4/packages/acs-tcl/tcl/community-core-procs-postgresql.xql 13 Mar 2004 13:49:17 -0000 1.17.2.2 +++ openacs-4/packages/acs-tcl/tcl/community-core-procs-postgresql.xql 13 Mar 2004 16:54:12 -0000 1.17.2.3 @@ -45,7 +45,7 @@ select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id - from acs_users_all u + from cc_users u where lower(coalesce(u.first_names || ' ', '') || coalesce(u.last_name || ' ', '') || u.email || ' ' || Index: openacs-4/packages/acs-tcl/tcl/community-core-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/community-core-procs.xql,v diff -u -r1.11.2.2 -r1.11.2.3 --- openacs-4/packages/acs-tcl/tcl/community-core-procs.xql 13 Mar 2004 13:49:17 -0000 1.11.2.2 +++ openacs-4/packages/acs-tcl/tcl/community-core-procs.xql 13 Mar 2004 16:54:12 -0000 1.11.2.3 @@ -4,15 +4,15 @@ - select user_id from acs_users_all where lower(screen_name) = lower(:screen_name) + select user_id from cc_users where lower(screen_name) = lower(:screen_name) - select user_id from acs_users_all where lower(email) = lower(:email) + select user_id from cc_users where lower(email) = lower(:email)