fedora-accounts dump-group.cgi,1.4,1.5

[Toshio Ernie Kuratomi (toshio)]

Author: toshio

Update of /cvs/fedora/fedora-accounts
In directory cvs-int.fedora.redhat.com:/tmp/cvs-serv32719

Modified Files:
	dump-group.cgi 
Log Message:
Select distinct entries so we don't get multiple entries for people when
searching all groups.



Index: dump-group.cgi
===================================================================
RCS file: /cvs/fedora/fedora-accounts/dump-group.cgi,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- dump-group.cgi	15 Aug 2007 23:45:15 -0000	1.4
+++ dump-group.cgi	17 Aug 2007 19:36:01 -0000	1.5
@@ -23,7 +23,7 @@
 
 dbc = dbh.cursor()
 qry = """
-SELECT person.username, person.email, person.human_name, role.role_type, person.id, role.project_group_id
+SELECT distinct person.username, person.email, person.human_name, role.role_type, person.id, role.project_group_id
 FROM role, person, project_group WHERE person.id = role.person_id AND project_group.id = role.project_group_id
 AND person.approval_status = 'approved' AND role.role_status = 'approved'
 """