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