Re: [SQLObject] question about Many to Many relations

[Rick F. <rf...@im...>]

You want to define the "intermediateTable" yourself. Use the keywords 
below to specify that you want to do so. This is a popular question which 
means that the docs don't answer it. So I should write up a:
   "How-to define your own intermediateTable with SQLRelatedJoin"

From: 
http://sqlobject.org/SQLObject.html#relatedjoin-and-sqlrelatedjoin-many-to-many

intermediateTable:
     The name of the intermediate table which references both classes.
     WARNING: you should pass the database table name, not the SQLO class
     representine.

createRelatedTable:
     default: True. If False, then the related table won't be automatically
     created; instead you must manually create it (e.g., with explicit
     SQLObject classes for the joins). New in 0.7.1.

If you need more info than this let me know.

--
Rick

On Fri, 17 Nov 2006, Alejandro Arbelaez wrote:

> Hi all,
>
>
> It is possible to create a primary key or unique key of the fields in the
> intermediate table when I use many to many relations, if it is possible how
> can I do that?.
>
> I'm working with sqlobject and sqlite as database schema.
>
>
> thanks in advance
> Alejandro
>