ok that worked... thanks
I suppose I had my eyes on this line of code...
db.person.update_or_insert(name='John',birthplace='Chicago')
Den tisdagen den 21:e maj 2013 kl. 19:18:29 UTC+2 skrev Anthony:
>
>
> *db(*
>> * db.tag.id==db.page_tag.tag_id, # do the JOIN*
>> * db.page_tag.page_id==page.id # do the WHERE*
>> *).select()*
>>
>
> Where did you see that syntax for a multi-condition query? For queries
> with multiple conditions, you either use & or chain calls to the Set
> objects:
>
> db((query1) & (query2) & (query3)).select()
>
> or
>
> db(query1)(query2)(query3).select()
>
> If you want to view the SQL generated by a select, call ._select() instead
> of .select() -- that will return a string with the SQL rather than actually
> executing the query (there's also ._update(), ._insert(), ._delete(), and
> ._count()). Another option is to include {{=response.toolbar()}} in the
> view, which includes a button to show all the queries done during the
> request (and how long they took). You can also access this information
> directly via db._timings at any time. Finally, db._lastsql can be used to
> view the most recently executed SQL command.
>
> Anthony
>
--
---
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/groups/opt_out.
