Index: openacs-4/packages/ecommerce/tcl/ecommerce-email-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-email-procs.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/ecommerce/tcl/ecommerce-email-procs.xql	18 Jul 2001 23:46:14 -0000	1.2
+++ openacs-4/packages/ecommerce/tcl/ecommerce-email-procs.xql	9 Mar 2002 02:00:02 -0000	1.3
@@ -154,15 +154,15 @@
       
     select user_id
       from cc_users
-     where upper(email)=upper(:email)
+     where email=lower(:email)
     
       </querytext>
 </fullquery>
 
  
 <fullquery name="user_identification_id_select">      
       <querytext>
-      select user_identification_id from ec_user_identification where upper(email)=upper(:email)
+      select user_identification_id from ec_user_identification where email=lower(:email)
       </querytext>
 </fullquery>