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.2 -r1.3 --- openacs-4/packages/dotlrn/www/member-add-oracle.xql 11 Feb 2002 22:03:23 -0000 1.2 +++ openacs-4/packages/dotlrn/www/member-add-oracle.xql 16 Mar 2002 02:02:07 -0000 1.3 @@ -1,15 +1,20 @@ - - - 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) - - + + + + 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) + + +