[DB-SIG] Cursor.description when Cursor.rowcount == 0
Carsten Haese
carsten at uniqsys.com
Fri Nov 10 19:37:28 CET 2006
On Fri, 2006-11-10 at 19:03 +0100, M.-A. Lemburg wrote:
> It is common practice to do
>
> cursor.execute('select * from mytable where 1=0')
> print cursor.description
I'm glad I'm not the only one doing this :)
> cursor.description always refers to a result set. If a statement
> does not produce a result set, then .description should be None.
I think the DB-API spec (or a future version thereof) should replace
"operations that do not return rows" with "operations that do not
produce a result set" to make this point clear.
-Carsten
More information about the DB-SIG
mailing list