Joost Moesker wrote: > Hi, > > I haven't been using SO for some time but i'm pretty sure you can use > the following: > Shot.selectBy(lead_td=user) > > or alternatively > Shot.select(Shot.q.lead_tdID==user.id) > > hope this works. > Cheers Joost,
The selectBy() technique isn't appropriate as once I get this working it will have more complex logic to it (AND, OR...). I think I tried lead_tdID but maybe not. I'll give it another shot. I'm only getting to code this in my spare time so it might be a day or two before I get back into the code. Thanks for you help. Rangi > On Sep 9, 4:41 pm, "Rangi Sutton" <[EMAIL PROTECTED]> wrote: > >> Hi folks, >> >> I'm trying to add some query logic to my fledgling app (with SO), but >> having a bit of trouble with select and foreign keys. The story with >> reduced complexity model: >> >> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---

