[python-sybase] How to interpret the cursor.rowcount?

Peter Hopfgartner hopfgartner at rolmail.net
26 May 2003 08:47:11 +0200


In fact, I DO the execute before. in any case, i will extract a small
test case and post it on the list. In the mean time I will continue with
0.36pre6.

Regards,

Peter


On Mon, 2003-05-26 at 02:00, Andrew McNamara wrote:
> >In particular, when a query does not return any matching
> >row, the versions up to 0.36pre6 set the value of
> >cursor.rowcount to 0 (what I really expected it to be).
> >With 0.36, the value becomes -1.
> 
> I would guess it's been done to improve compliance with the Python
> Database API Specification 2.0, which has the following to say about
> rowcount:
> 
>     This read-only attribute specifies the number of rows that the last
>     executeXXX() produced (for DQL statements like select) or affected
>     (for DML statements like update or insert).
> 
>     The attribute is -1 in case no executeXXX() has been performed on
>     the cursor or the rowcount of the last operation is not determinable
>     by the interface.[7]
-- 
Peter Hopfgartner <hopfgartner@rolmail.net>