* 'VirtualMailManager/Domain.py'
authorPascal Volk <neverseen@users.sourceforge.net>
Sat, 23 Aug 2008 15:32:12 +0000
changeset 58 1692da96ec17
parent 57 38c42e09677a
child 59 f2f784667040
* 'VirtualMailManager/Domain.py' - Corrected query in Domain.getAliases()
VirtualMailManager/Domain.py
--- 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 = []