Re: [sqlite] last_insert_rowid() syntax

2008-10-27 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Karl Lautman wrote: > Thanks, Roger. Your second suggestion does the trick. The first, however, > returns: . Can you explain why? > Thanks again. Both pysqlite make the cursor an iterator. Remember that a query can return zero, one or more rows o

Re: [sqlite] last_insert_rowid() syntax

2008-10-26 Thread Karl Lautman
SQLite Database Subject: Re: [sqlite] last_insert_rowid() syntax -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Karl Lautman wrote: > Can someone point out to me the syntax error in the following? I've omitted > the set-up code for brevity, but cur is a cursor with a connection to the

Re: [sqlite] last_insert_rowid() syntax

2008-10-26 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Karl Lautman wrote: > Can someone point out to me the syntax error in the following? I've omitted > the set-up code for brevity, but cur is a cursor with a connection to the > database. Thanks. > x = cur.execute('last_insert_rowid()') last_i

[sqlite] last_insert_rowid() syntax

2008-10-26 Thread Karl Lautman
Can someone point out to me the syntax error in the following? I've omitted the set-up code for brevity, but cur is a cursor with a connection to the database. Thanks. >>> x = cur.execute('last_insert_rowid()') Traceback (most recent call last): File "", line 1, in x = cur.execute('las