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.8 -r1.9
--- openacs-4/packages/dotlrn/www/member-add-oracle.xql	9 Nov 2008 23:29:23 -0000	1.8
+++ openacs-4/packages/dotlrn/www/member-add-oracle.xql	3 Apr 2009 12:25:08 -0000	1.9
@@ -6,17 +6,14 @@
 
     <fullquery name="select_users">
         <querytext>
-            select user_id,
-                   first_names,
-                   last_name,
-                   email
-            from dotlrn_users
-            where lower(last_name) like lower('%' || :search_text || '%')
-            or lower(first_names) like lower('%' || :search_text || '%')
-            or lower(email) like lower('%' || :search_text || '%')
-            and user_id not in (select user_id
-                                from dotlrn_member_rels_full
-                                where community_id = :community_id)
+            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 || '%')
         </querytext>
     </fullquery>