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 > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ sqlobject-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
