Re: [newbie] Right way to access item in array?

[Gilles Ganault]

On Tue, 28 Oct 2008 12:12:26 +0100, Gerhard Häring <[EMAIL PROTECTED]>
wrote:
>You can do it even in one step with APSW (and pysqlite, and others):
>
>for isbn, price in cur.execute("select isbn, price ..."):

Thanks much guys. For those interested, here's some working code:

======
import apsw

connection=apsw.Connection("mybooks.sqlite")
cursor=connection.cursor()

for id, isbn in list(cursor.execute("SELECT id,isbn FROM books WHERE
price IS NULL")):

        print isbn

connection.close(True)
======

HTH,
--
http://mail.python.org/mailman/listinfo/python-list