Inserts create new records, so there is no sense in which a "where" condition would apply. Perhaps instead you want to do an update to an existing record or set of records, in which case, see the .update() method of the Set class here: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#The-DAL--A-quick-tour.
Anthony On Thursday, May 28, 2015 at 3:32:01 PM UTC-4, Alessio Varalta wrote: > > Hi i don't find on the guide the method to execute a query with where > condition... i see > > db.class.insert but i don t find a method to use this with where condition > or i use > > db.executesql("Insert into auth_user('person') values(4) where > auth_user.id=38;") > > but i receive a error > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.