Re: Committing delete with execute()

2005-11-20 Thread David Pratt
Ok, super. Just thought I would verify this. Many thanks. Regards, David On Sunday, November 20, 2005, at 01:37 PM, Adrian Holovaty wrote: On 11/19/05, David Pratt <[EMAIL PROTECTED]> wrote: This seems to be fine for inserts but I found with delete statements, I must be explicit about c

Re: Committing delete with execute()

2005-11-20 Thread Adrian Holovaty
On 11/19/05, David Pratt <[EMAIL PROTECTED]> wrote: > This seems to be fine for inserts but I found with delete statements, I > must be explicit about committing the transaction using db.commit(). > Can someone advise whether this is the behavior I should expect from > django's api or whether the

Committing delete with execute()

2005-11-19 Thread David Pratt
Hi. I have been using the django db api for a project using SQLite-3.2.7 with pysqlite-2.0.5. The form of my more complicated sql statements have been of the form: from django.core.db import db query = "SELECT ... the rest of my query ..." cursor = db.cursor() cursor.execute(query) records