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