Index: openacs-4/packages/acs-admin/www/users/member-state-change-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/member-state-change-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-admin/www/users/member-state-change-postgresql.xql	27 Apr 2001 01:41:12 -0000	1.1
+++ openacs-4/packages/acs-admin/www/users/member-state-change-postgresql.xql	28 Apr 2001 19:58:38 -0000	1.2
@@ -5,9 +5,11 @@
 
 <fullquery name="get_states">      
       <querytext>
-      select email_verified_p email_verified_p_old, member_state member_state_old, first_names || ' ' || last_name as name, email, rel_id, rowid
-from cc_users
-where user_id = :user_id
+      select email_verified_p as email_verified_p_old,
+             member_state as member_state_old,
+             first_names || ' ' || last_name as name, email, rel_id, oid
+      from cc_users
+      where user_id = :user_id
       </querytext>
 </fullquery>