Index: openacs-4/packages/acs-admin/www/users/one.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/one.xql,v
diff -u -N -r1.6 -r1.6.2.1
--- openacs-4/packages/acs-admin/www/users/one.xql	21 Feb 2002 17:13:17 -0000	1.6
+++ openacs-4/packages/acs-admin/www/users/one.xql	20 Apr 2002 22:23:44 -0000	1.6.2.1
@@ -26,7 +26,7 @@
 
 <fullquery name="all_group_membership">
   <querytext>
-    select groups.group_id, groups.group_name
+    select distinct lower(groups.group_name) as group_name
       from groups, group_member_map gm
      where groups.group_id = gm.group_id and gm.member_id=:user_id
   order by lower(groups.group_name)