[Zope] SQLMethods: getting # of rows updated

Jeffrey Shell Jeffrey@digicool.com
Tue, 14 Sep 1999 12:35:37 -0400


> When a SQLMethod is called that modifies data through an UPDATE or
> INSERT statement, is there any way of finding out how many rows were 
> affected by the change?  

Some databases may expose this information in a special object.  If it's
a selectable object (not a stored procedure), it's easy to get the
information.  But by default, most databases don't return any
information about how many rows were affected by a statement.  And those
that do probably don't do it in a uniform way.