Imagine that I defined a pair of tables as
db.define_table('stuff',
Field('nickname', 'string'),
Field('durations', 'list:integer'),
Field('tones, 'list:string'))
db.define_table('nonsense',
Field('Chapter', 'string'),
Field('timing', 'integer'),
Field('norm', 'string'))
If I know a nonsense.timing I'm interested in is 10, I can find the stuff
that matches with
db.(db.stuff.durations.contains(10))
and the stuff that matches a nonsense.norm of "cflat" with
db.(db.stuff.tones.contains('cflat'))
But if I want to do a join, rather than a manual iteration (or nested
selects), where the stuff.durations contains a match for some
nonsense.timing or where the stuff.tones contains a match for some
nonsense.norm, how do I write that?
Thanks.
Dave S
/dps
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/2eea53fb-a9d5-4c73-ad90-b8f5b4267a94n%40googlegroups.com.
