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 || '%')
-
-
-