VirtualMailManager/Domain.py
changeset 58 1692da96ec17
parent 56 9ae1b1b2ee5c
child 76 14c0a092d7d2
--- a/VirtualMailManager/Domain.py	Sat Aug 23 03:00:30 2008 +0000
+++ b/VirtualMailManager/Domain.py	Sat Aug 23 15:32:12 2008 +0000
@@ -243,8 +243,8 @@
     def getAliases(self):
         """Returns a list with all aliases from the domain."""
         dbc = self._dbh.cursor()
-        dbc.execute("SELECT address from alias where gid = %s ORDER BY address",
-                self._id)
+        dbc.execute("SELECT DISTINCT address FROM alias WHERE gid = %s\
+ ORDER BY address",  self._id)
         addresses = dbc.fetchall()
         dbc.close()
         aliases = []