Tim Black schrieb:
> I've tried to represent this simply as:
>
> class Person(SQLObject):
> name = StringCol()
> clientProjects = RelatedJoin("Project")
> contractorProjects = RelatedJoin("Project")
>
> class Project(SQLObject):
> name = StringCol()
> clients = RelatedJoin("Person")
> contractors = RelatedJoin("Person")
>
> But, when I add a client to a project in Catwalk, that client appears as
> a contractor as well on the same project! Makes sense; for example, I
> shouldn't expect SQLObject to distinguish between two identical
> references to RelatedJoin("Project"). But how can I distinguish the two
> references properly?
Hi,
this quite a shot in the dark but AFAIK you can specify the intermediate
table manually in the foo = RelatedJoin() statement. Look at the docs, I
guess it takes a intermediateTable keyword. This way if you add a
contractor it would go in the. You might need to add those intermediate
tables by hand.
cheers
Paul
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
