diff -r d5ad5432e9eb -r 48ea255e8a85 VirtualMailManager/Domain.py --- a/VirtualMailManager/Domain.py Sat Apr 26 02:49:34 2008 +0000 +++ b/VirtualMailManager/Domain.py Mon Apr 28 21:33:28 2008 +0000 @@ -214,7 +214,8 @@ def getAccounts(self): """Returns a list with all accounts from the domain.""" dbc = self._dbh.cursor() - dbc.execute("SELECT userid AS users FROM dovecot_user WHERE gid = %s", + dbc.execute("SELECT userid AS users FROM dovecot_user WHERE gid = %s\ + ORDER BY users", self._id) users = dbc.fetchall() dbc.close() @@ -227,7 +228,8 @@ def getAliases(self): """Returns a list with all aliases from the domain.""" dbc = self._dbh.cursor() - dbc.execute("SELECT DISTINCT address FROM postfix_alias WHERE gid=%s", + dbc.execute("SELECT DISTINCT address FROM postfix_alias WHERE gid=%s\ + ORDER BY address", self._id) addresses = dbc.fetchall() dbc.close()