Re: difference between statements
Gerhard Häring <[email protected]>
| Newsgroups | gmane.comp.python.db.pysqlite.user |
|---|---|
| Message-ID | <[email protected]> |
[email protected] wrote: > I very rarely work directly in sqlite, but Deletes and Inserts have to > have a con.commit() after them. > > Also you may be having a problem which I have experienced, if a query > contains parentheses then paremeter substitution fails. In other words > if I have a query like this: > > cur.execute("""select * from Products where ProductID = (select > ProductID from Sponsor where SponsorID = ?)""", (12,)) [...] Works fine here (tried with SQLite 3.3.5). -- Gerhard