Re: [web2py] Re: How to get the referenced objects from a list:reference

2011-08-22 Thread Richard Vézina
Forget my comment... I didn't read carefully what you were trying to do... I forgot also that my issue was only with self-referenced table... Richard On Mon, Aug 22, 2011 at 3:07 PM, Richard Vézina wrote: > I report this last week > > Here : > http://groups.google.com/group/fameisfame/browse_t

Re: [web2py] Re: How to get the referenced objects from a list:reference

2011-08-22 Thread Richard Vézina
I report this last week Here : http://groups.google.com/group/fameisfame/browse_thread/thread/8a65568330aa25dd/2014ffb6852c4874?lnk=raot&pli=1 I think I should open a issue... Richard On Mon, Aug 22, 2011 at 2:27 PM, fishwebby wrote: > Yeh, that's what I've found myself doing. Now that I'm ju

[web2py] Re: How to get the referenced objects from a list:reference

2011-08-22 Thread fishwebby
Yeh, that's what I've found myself doing. Now that I'm just assuming that the datastore is a list of objects identified by keys, I'm getting on much better with it (although like you say, some of my controller code is a little ugly but worth the price I think!) Cheers Dave On Aug 21, 11:56 pm, h

[web2py] Re: How to get the referenced objects from a list:reference

2011-08-21 Thread howesc
the challenge is that you are thinking about a normalized referential DB. GAE does not provide that at this time. so you have warp your mind to get it to work. flat schemas work best, but they are hard to manage and very ugly, so it's all about finding that middle ground. at the same time, G

[web2py] Re: How to get the referenced objects from a list:reference

2011-08-21 Thread fishwebby
Just tried that, and all that does is return a comma separated list of the course titles - a bit closer but I need the objects really as I want to access other properties of them. I'm beginning to think that either I don't understand GAE enough or it's not useful for the app I'm developing (which

[web2py] Re: How to get the referenced objects from a list:reference

2011-08-20 Thread Anthony
Does db.person.courses.represent(person.coures) work? See http://web2py.com/book/default/chapter/06#Many-to-Many,-list:,-and-contains . Anthony On Saturday, August 20, 2011 1:58:04 PM UTC-4, fishwebby wrote: > Hi, I'm trying to do something quite straightforward but can't seem to > work out h

[web2py] Re: How to get the referenced objects from a list:reference

2011-08-20 Thread howesc
i have not found a way to do that without querying the referenced table, so if there is a way to do it i have missed it too. cfh