On Thu, Jul 31, 2008 at 2:10 PM, Jerome Kerdreux <[EMAIL PROTECTED]> wrote: > class PhotosTags(SQLObject): > class sqlmeta: > table = 'photo_tags' > photo = ForeignKey('Photo') > tag = ForeignKey('Tag')
> Ok, but the right column in the intermediate table is this : > TABLE photo_tags ( photo_id INTEGER, tag_id INTEGER ); > > As you can see the columns are photo_id and tag_id .. but SQLO is looking for > photos_id and tags_id (look the s at the end).. Have you tried: photo = ForeignKey('Photo', dbName='photo_id') tag = ForeignKey('Tag', dbName='tag_id') [See top of http://www.sqlobject.org/SQLObject.html#col-class-specifying-columns in the docs] ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss