~azzar1/unity/add-show-desktop-key

« back to all changes in this revision

Viewing changes to lib/common/db.py

  • Committer: wagrant
  • Date: 2008-09-12 23:18:31 UTC
  • Revision ID: svn-v3-trunk0:2b9c9e99-6f39-0410-b283-7f802c844ae2:trunk:1045
common.db: Order offering members by login.

Show diffs side-by-side

added added

removed removed

Lines of Context:
975
975
SELECT login.login AS login, login.fullname AS fullname
976
976
FROM login, enrolment
977
977
WHERE login.loginid = enrolment.loginid AND
978
 
    enrolment.offeringid = %d;"""%offeringid
 
978
    enrolment.offeringid = %d
 
979
    ORDER BY login.login;"""%offeringid
979
980
        if dry:
980
981
            return query
981
982
        return self.db.query(query).dictresult()