VirtualMailManager/Domain.py
changeset 24 48ea255e8a85
parent 18 c98e08791ee8
child 32 ceb700bc4a80
--- 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()