[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>