Index: openacs-4/packages/dotlrn/www/member-add-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/member-add-oracle.xql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/dotlrn/www/member-add-oracle.xql 3 Apr 2009 12:25:08 -0000 1.9
+++ openacs-4/packages/dotlrn/www/member-add-oracle.xql 28 Apr 2009 12:01:31 -0000 1.10
@@ -4,17 +4,4 @@
oracle8.1.6
-
-
- select a.user_id, a.first_names, a.last_name, a.email,
- case when b.user_id is not null then 1 else 0 end as member_p
- from dotlrn_users a
- left outer join (select user_id from dotlrn_member_rels_full where community_id = :community_id) b
- on (a.user_id = b.user_id)
- where lower(a.last_name) like lower('%' || :search_text || '%')
- or lower(a.first_names) like lower('%' || :search_text || '%')
- or lower(a.email) like lower('%' || :search_text || '%')
-
-
-
Index: openacs-4/packages/dotlrn/www/member-add-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/member-add-postgresql.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/dotlrn/www/member-add-postgresql.xql 3 Apr 2009 12:25:08 -0000 1.5
+++ openacs-4/packages/dotlrn/www/member-add-postgresql.xql 28 Apr 2009 12:01:32 -0000 1.6
@@ -4,17 +4,4 @@
postgresql7.1
-
-
- select a.user_id, a.first_names, a.last_name, a.email,
- case when b.user_id is not null then 1 else 0 end as member_p
- from dotlrn_users a
- left outer join (select user_id from dotlrn_member_rels_full where community_id = :community_id) b
- on (a.user_id = b.user_id)
- where lower(a.last_name) like lower('%' || :search_text || '%')
- or lower(a.first_names) like lower('%' || :search_text || '%')
- or lower(a.email) like lower('%' || :search_text || '%')
-
-
-
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/dotlrn/www/member-add.xql'.
Fisheye: No comparison available. Pass `N' to diff?