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