Index: openacs-4/packages/acs-admin/www/users/user-add-2.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/Attic/user-add-2.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/acs-admin/www/users/user-add-2.xql 29 Apr 2001 00:47:48 -0000 1.3 +++ openacs-4/packages/acs-admin/www/users/user-add-2.xql 9 Mar 2002 02:00:02 -0000 1.4 @@ -4,28 +4,10 @@ select count(email) -from parties where upper(email) = :upper_email +from parties where email = lower(:email) and party_id <> :user_id - - - select count(email) -from parties where upper(email) = :upper_email -and party_id <> :user_id - - - - - - - select count(email) -from parties where upper(email) = :upper_email -and party_id <> :user_id - - - -