# HG changeset patch # User Pascal Volk # Date 1219505532 0 # Node ID 1692da96ec178d18a613744103d9a3b0137494dd # Parent 38c42e09677a9558bcf84700d79e309a85c76288 * 'VirtualMailManager/Domain.py' - Corrected query in Domain.getAliases() diff -r 38c42e09677a -r 1692da96ec17 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 = []