Index: openacs-4/packages/dotlrn/www/community-user-add.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/community-user-add.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/dotlrn/www/community-user-add.xql 27 Nov 2001 23:32:03 -0000 1.1 +++ openacs-4/packages/dotlrn/www/community-user-add.xql 3 Dec 2001 02:51:27 -0000 1.2 @@ -4,7 +4,7 @@ -select user_id, first_names, last_name, email from dotlrn_users_full where lower(last_name) like lower('%' || :search_text || '%') or lower(email) like lower('%' || :search_text || '%') and user_id not in (select user_id from dotlrn_member_rels_full where community_id= :community_id) +select user_id, first_names, last_name, email from dotlrn_full_users where lower(last_name) like lower('%' || :search_text || '%') or lower(email) like lower('%' || :search_text || '%') and user_id not in (select user_id from dotlrn_member_rels_full where community_id= :community_id)