John Nagle wrote:
> Carl K wrote:
>> using MySQLdb, I do cursor.execute("update...")
>>
>> How can I tell how many rows were affected ?
>>
>> Carl K
>
> cursor = db.cursor() # get cursor
> cursor.execute(sqlstatement, argtuple) # do command
> rowsaffected = cursor.rowcount # get count of rows affected
> cursor.close() # close cursor
> db.commit() # commit transaction
>
> John Nagle cursor.rowcount - bingo. Thanks a bunch. Carl K -- http://mail.python.org/mailman/listinfo/python-list
