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.2.2.1 --- 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 22 Dec 2003 17:19:47 -0000 1.2.2.1 @@ -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 Index: openacs-4/packages/acs-subsite/www/members/member-invite-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/members/Attic/member-invite-postgresql.xql,v diff -u -r1.2 -r1.2.2.1 --- openacs-4/packages/acs-subsite/www/members/member-invite-postgresql.xql 28 Aug 2003 09:41:41 -0000 1.2 +++ openacs-4/packages/acs-subsite/www/members/member-invite-postgresql.xql 22 Dec 2003 17:19:47 -0000 1.2.2.1 @@ -11,7 +11,7 @@ coalesce(u.last_name || ' ', '') || u.email || ' ' || coalesce(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