python mysql delete statement not working
<p>here I am trying to remove any users which containt a " in their email/username.</p>

<pre><code>    def removeQuote(self, tbl,record):
            """ Updates the record """
            statmt="select id from %s WHERE `email` LIKE '%%\"%%'" % (tbl)
            self.cursor.execute(statmt)
            rows=list(self.cursor.fetchall())
            for idx, val in enumerate(rows):
                    id= val[0]
                    delstatmt = "DELETE FROM `maillist_subscription` WHERE id = '%s'" % id
                    print delstatmt
                    self.cursor.execute(delstatmt)
</code></pre>

<p>The output of this shows as if the action completed successfully, but the record remains in the database.
Output also shows a correct mysql statement:</p>

<pre><code>DELETE FROM `maillist_subscription` WHERE id = '8288754'
</code></pre>

<p>Thanks for all your help!</p>
