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
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/dotlrn/www/member-add-oracle.xql	11 Feb 2002 17:17:17 -0000	1.1
@@ -0,0 +1,26 @@
+<?xml version="1.0"?>
+
+<queryset>
+  <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(email) like lower('%' || :search_text || '%')
+      and user_id not in (select user_id
+                          from dotlrn_member_rels_full
+                          where community_id = :community_id)
+      and user_id in (select decode((select parent_id
+                                     from dotlrn_communities
+                                     where community_id = :community_id), 
+                                     NULL, 
+                                     (select user_id from dotlrn_users), 
+                                     (select user_id 
+                                     from dotlrn_member_rels_full 
+                                     where community_id = (select parent_id 
+                                                           from dotlrn_communities 
+                                                           where community_id = :community_id)))
+                      from dual)
+    </querytext>
+  </fullquery>
+</queryset>
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?