Index: openacs-4/packages/acs-subsite/www/members/member-invite-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/members/Attic/member-invite-oracle.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/acs-subsite/www/members/member-invite-oracle.xql 28 Aug 2003 09:41:41 -0000 1.2 +++ openacs-4/packages/acs-subsite/www/members/member-invite-oracle.xql 26 Jan 2004 15:39:46 -0000 1.3 @@ -12,7 +12,7 @@ nvl(u.last_name || ' ', '') || u.email || ' ' || nvl(u.screen_name, '')) like upper('%'||:value||'%') - and not exists (select 1 from acs_rels where object_id_one = $group_id and object_id_two = u.user_id) + and not exists (select 1 from acs_rels where object_id_one = $group_id and object_id_two = u.user_id and rel_type = 'membership_rel') order by name