I would very much like to include this but this has to work on all supported databases. Can you send me a patch? It will be included.
On Dec 15, 2:26 am, billf <[email protected]> wrote: > I would like access to the rowcount returned from update and delete > actions. There are a couple of reasons: > > a) it could be used to detect rare errors, e.g. expect 1 row to be > updated and zero returned. > > b) if the update/delete affects several rows, I'd like to know how > many rows were updated without running a separate select, e.g. > rowcount=db(db.employee.role==request.vars.role).update(request.vars) > > I believe that this can be achieved quite simply by a patch to sql.py > update() and delete() methods. > > Change "self._db._execute(query)" to "return self._db._execute(query)" > > If you wanted to access "rowcount" with SQLFORM then other changes > would be required. > > My questions are: > > 1) can anyone see a problem with the suggestion? > > 2) does anyone object to including the proposed patch? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
