David Wahler <[EMAIL PROTECTED]> wrote:
...
> Tuples are immutable (can't be modified once created). Try this:
>
> def BDllids():
> conn = sqlite.connect('tasques.db')
> cursor = conn.cursor()
> cursor.execute('SELECT * FROM tasques')
> a = [row[0] for row in cursor]
> return tuple(a)
>
> Is there some particular reason you need to return a tuple as opposed to a
> list?
Assuming there is (need to use it as a dict key, RHS operand of string
formatting % operator, etc) I would suggest collapsing the last 2
statements in your excellent code into
return tuple(row[0] for row in cursor)
> P.S. Accessing fields of a SELECT * by numeric index is prone to
> breakage if the order of your fields changes. You can make your code
> more robust by either specifying the column name explicitly in the
> SELECT statement. Alternatively, you may be interested in the
Absolutely true -- in this case, return tuple(cursor) will suffice.
Alex
--
http://mail.python.org/mailman/listinfo/python-list
