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