Index: openacs-4/packages/dotlrn-catalog/www/dt-admin/grant-user-list.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/www/dt-admin/grant-user-list.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/dotlrn-catalog/www/dt-admin/grant-user-list.xql	14 Feb 2005 22:46:11 -0000	1.1
+++ openacs-4/packages/dotlrn-catalog/www/dt-admin/grant-user-list.xql	16 Feb 2005 22:21:30 -0000	1.2
@@ -14,7 +14,7 @@
       <querytext>
 	  select first_names, last_name, user_id as p_user_id, email as db_email
 	  from cc_users where user_id <> :user_id
-	  and (lower(first_names) like '%$user_name%'
+	  and (lower(first_names) like lower('%$user_name%')
    	  or lower(last_name) like '%$user_name%') order by first_names, last_name
       </querytext>
 </fullquery>
@@ -23,16 +23,16 @@
       <querytext>
 	  select first_names, last_name, user_id as p_user_id, email as db_email
 	  from cc_users where user_id <> :user_id 
-	  and lower(email) like '%$user_email%' order by email
+	  and lower(email) like lower('%$user_email%') order by email
       </querytext>
 </fullquery>
 
 <fullquery name="select_users_name_email">      
       <querytext>
 	  select first_names, last_name, user_id as p_user_id, email as db_email
-	  from cc_users where user_id <> :user_id 
-	  lower(first_names) like '%$user_name%' or lower(last_name) like '%$user_name%')
-	  and lower(email) like '%$user_email%' order by email
+	  from cc_users where user_id <> :user_id and (
+	  lower(first_names) like lower('%$user_name%') or lower(last_name) like lower('%$user_name%'))
+	  and lower(email) like lower('%$user_email%') order by email
       </querytext>
 </fullquery>