Scratch my earlier mail. I wasn't using the joinColumn attribute.
Thats why they say RTFM.

cheers,
Diwaker

On 3/5/06, Diwaker Gupta <[EMAIL PROTECTED]> wrote:
> > It doesn't.
> >
> > I use it all the time.  When I' doing some auditing I have
> >
> >     changedBy = ForeignKey('User', notNone = True)
>
> It still doesn't work for me. The table gets generated alright, but
> when I try to query something, it breaks.
>
> Right now I have something like:
>
> class Expense(SQLObject):
>     date = DateCol()
>     description = StringCol()
>     amount = CurrencyCol()
>     sharedBy = MultipleJoin("Share")
>
> class Share(SQLObject):
>     eid = ForeignKey("Expense")
>
> I add an Expense, and then try to do e.sharedBy from the shell, I get
> this (the unknown column expense_id is towards the end):
>
> 1/QueryAll:  SELECT id FROM share WHERE expense_id = 1
>

--
Web/Blog/Gallery: http://floatingsun.net/blog

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to