so.. how do we get rowcount on mssql? Massimo
On Dec 16, 3:36 pm, billf <[email protected]> wrote: > It's probably obvious but note thatinsert returns the id of the > inserted record while update and delete returns the number of rows > affected. > > So the "1" returned by the insert is not "one row inserted" but "row > inserted with id=1" > > On Dec 16, 8:47 pm, DenesL <[email protected]> wrote: > > > In MSSQL 2005: > > > >>> db.define_table('t',SQLField('a')) > > ... > > >>> db.t.insert(a='test') > > 1 > > >>> print db(db.t.id>0).delete() > > > None --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
