[web2py] Re: Many to Many on GAE

2010-12-13 Thread howesc
where and how are the pictures stores? will you be adding them to the blobstore or references pictures elsewhere?

[web2py] Re: Many to Many on GAE

2010-12-12 Thread Arun K.Rajeevan
Thank you for reply. My problem is, I have problem in choosing one approach over other. 1) Use a mapping table 2) Or use list reference. My tables are something like this: Table :Picture & Word Word: Coffee: Picture: Both the picture below represent word coffee. (ie., for one word many pictures)

[web2py] Re: Many to Many on GAE

2010-12-11 Thread howesc
Arun, this line: persons_and_dogs = db((db.person.id==db.ownership.person) & (db.dog.id==db.ownership.dog)) won't run on GAE because of the joins. You can choose to keep the data structure as you have it and run 2 queries and mesh the results. before the advent of list properties i was doing that