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.

Reply via email to