Index: openacs-4/packages/acs-subsite/www/register/email-password-2.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/register/Attic/email-password-2.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/www/register/email-password-2.xql	1 May 2001 21:20:18 -0000	1.1
+++ openacs-4/packages/acs-subsite/www/register/email-password-2.xql	9 Sep 2001 14:02:45 -0000	1.2
@@ -5,7 +5,6 @@
       <querytext>
       select 
 email from cc_users where user_id=:user_id
--- and user_state in ('authorized','deleted')
       </querytext>
 </fullquery>
 
@@ -19,7 +18,7 @@
  
 <fullquery name="first_last_name">      
       <querytext>
-      select first_names db_first_names, last_name db_last_name from cc_users where user_id = $user_id
+      select first_names as db_first_names, last_name as db_last_name from cc_users where user_id = $user_id
       </querytext>
 </fullquery>