Thanks, Michael, it works as expected. -Samuel
On Sun, 2006-09-24 at 15:11 -0400, Michael Bayer wrote: > thats just result.rowcount, which is taken directly from "rowcount" > off the underlying Cursor. youll get that in all cases. note that > for an executemany(), DBAPI unfortunately does not aggregate the > total rowcount across individual executions so its somewhat useless > for an executemany. > > > On Sep 23, 2006, at 8:43 PM, Samuel Abels wrote: > > > Thanks for the information. > > > > I have also been trying to find a way to retrieve the number of > > affected > > rows after a DELETE operation. The docs mention that this can be done > > using the ResultProxy, but I have not found any method that might > > provide this kind of information. Any hints? > > > > Thanks, > > -Samuel > > > > On Sat, 2006-09-23 at 18:06 -0400, Michael Bayer wrote: > >> ah, sorry, I just committed to SVN a more descriptive error message > >> for what that is. the extra functions like last_inserted_ids etc. > >> drive off of an ExecutionContext object which is not created when > >> executing literal SQL strings. youd have to use a metadata-generated > >> SQL clause to get the extra functionality. > >> > >> the new error message when you try to call off a nonexistent > >> execution context is: > >> > >> This ResultProxy does not have an execution context with which to > >> complete this operation. Execution contexts are not generated for > >> literal SQL execution. > > > > > > ---------------------------------------------------------------------- > > --- > > Take Surveys. Earn Cash. Influence the Future of IT > > Join SourceForge.net's Techsay panel and you'll get the chance to > > share your > > opinions on IT & business topics through brief surveys -- and earn > > cash > > http://www.techsay.com/default.php? > > page=join.php&p=sourceforge&CID=DEVDEV > > _______________________________________________ > > Sqlalchemy-users mailing list > > Sqlalchemy-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
