Help with query

[Pepe Araya]

Hi!

In words what i need is to get a set from this query: select the 'persons.email' and 'persons.id' from table 'persons' that are not in table 'invitations.to'

my tables:

db.define_table('persons',
 Field('name'),
 Field('email'))

db.define_table('invitations',
 Field('from',db.persons),
 Field('to',db.persons))

Any help is welcome.

Thank you very much.

[Anthony]

Check out .belongs() -- http://web2py.com/books/default/chapter/29/06#belongs.

Anthony

[Derek]

You can negate a part of a query by using a tilde (~).

[Pepe Araya]

Hi Derek and Anthony, 

that's make the trick!!

Thank you both!!

Pepe Araya

Diseñador / Designer

--
 
---
You received this message because you are subscribed to a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/OOFjQug73q0/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Massimo Di Pierro]

Do not use to and from in field names. You will get into trouble.