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.2 -r1.3 --- openacs-4/packages/dotlrn/www/community-user-add.xql 3 Dec 2001 02:51:27 -0000 1.2 +++ openacs-4/packages/dotlrn/www/community-user-add.xql 11 Dec 2001 00:27:59 -0000 1.3 @@ -4,7 +4,7 @@ -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) +select user_id, first_names, last_name, email from dotlrn_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)