Gilles Ganault wrote:
> Hello
>
> I'd like to know what the right way is to access an item in a row as
> returned by a database:
>
> =====
> import apsw
>
> connection=apsw.Connection("test.sqlite")
> cursor=connection.cursor()
>
> rows=cursor.execute("SELECT isbn,price FROM books WHERE price IS
> NULL")
> for row in rows:
>
> #Is this right?
> for isbn in row:
No. This will iterate though all columns, not just the isbn.
You can use tuple-unpacking in such cases:
for row in rows:
isbn, price = row
...
Diez
--
http://mail.python.org/mailman/listinfo/python-list
