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 -N
--- openacs-4/packages/acs-subsite/www/members/member-invite-oracle.xql 26 Jan 2004 15:39:46 -0000 1.3
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,22 +0,0 @@
-
-
-
- oracle8.1.6
-
-
-
-
- select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id
- from cc_users u
- where upper(nvl(u.first_names || ' ', '') ||
- 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 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 -N
--- openacs-4/packages/acs-subsite/www/members/member-invite-postgresql.xql 26 Jan 2004 15:39:46 -0000 1.3
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,24 +0,0 @@
-
-
-
- postgresql7.1
-
-
-
- select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id
- from cc_users u
- where upper(coalesce(u.first_names || ' ', '') ||
- 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 rel_type = 'membership_rel')
- order by name
-
-
-
-
-
-
-
-
-