diff -r 4bba5fb90b78 -r 22d115376e4d VirtualMailManager/maillocation.py --- a/VirtualMailManager/maillocation.py Sat Aug 07 05:16:26 2010 +0000 +++ b/VirtualMailManager/maillocation.py Sat Aug 07 20:01:19 2010 +0000 @@ -130,8 +130,8 @@ *directory* name. If it fails goto _save().""" dbc = self._dbh.cursor() dbc.execute("SELECT mid FROM maillocation WHERE fid = (SELECT fid " - "FROM mailboxformat WHERE format = '%s') AND directory = " - "'%s'" % (mbfmt, directory)) + "FROM mailboxformat WHERE format = %s) AND directory = %s", + (mbfmt, directory)) result = dbc.fetchone() dbc.close() if not result: @@ -147,8 +147,8 @@ dbc.execute("SELECT nextval('maillocation_id')") mid = dbc.fetchone()[0] dbc.execute("INSERT INTO maillocation (fid, mid, directory) VALUES (" - "(SELECT fid FROM mailboxformat WHERE format = '%s'), %u, " - "'%s')" % (mbfmt, mid, directory)) + "(SELECT fid FROM mailboxformat WHERE format = %s), %s, " + "%s)", (mbfmt, mid, directory)) self._dbh.commit() dbc.close() self._mid = mid