Index: openacs-4/packages/dotlrn/www/admin/user-new.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/user-new.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/dotlrn/www/admin/user-new.xql 7 Nov 2001 15:52:19 -0000 1.1 +++ openacs-4/packages/dotlrn/www/admin/user-new.xql 10 Jan 2002 21:19:32 -0000 1.2 @@ -1,11 +1,17 @@ - - - -select user_id, first_names, last_name, email from registered_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_users) - - - + + + select user_id, + first_names, + last_name, + email + from registered_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_users) + +