VirtualMailManager/transport.py
branchv0.6.x
changeset 352 22d115376e4d
parent 321 883d5cd66498
child 360 44283818f8db
--- a/VirtualMailManager/transport.py	Sat Aug 07 05:16:26 2010 +0000
+++ b/VirtualMailManager/transport.py	Sat Aug 07 20:01:19 2010 +0000
@@ -69,7 +69,8 @@
     def _load_by_id(self):
         """load a transport by its id from the database"""
         dbc = self._dbh.cursor()
-        dbc.execute('SELECT transport FROM transport WHERE tid=%s', self._tid)
+        dbc.execute('SELECT transport FROM transport WHERE tid = %s',
+                    (self._tid,))
         result = dbc.fetchone()
         dbc.close()
         if result:
@@ -82,7 +83,7 @@
         """Load a transport by its transport name from the database."""
         dbc = self._dbh.cursor()
         dbc.execute('SELECT tid FROM transport WHERE transport = %s',
-                    self._transport)
+                    (self._transport,))
         result = dbc.fetchone()
         dbc.close()
         if result:
@@ -95,8 +96,8 @@
         dbc = self._dbh.cursor()
         dbc.execute("SELECT nextval('transport_id')")
         self._tid = dbc.fetchone()[0]
-        dbc.execute('INSERT INTO transport VALUES (%s, %s)', self._tid,
-                    self._transport)
+        dbc.execute('INSERT INTO transport VALUES (%s, %s)', (self._tid,
+                    self._transport))
         self._dbh.commit()
         dbc.close()