On Thu, Jul 31, 2008 at 2:10 PM, Jerome Kerdreux <[EMAIL PROTECTED]> wrote:
>
>
> Hi, all.
>
>
> And here is the result code.
>
>
> class Photo(SQLObject):
> class sqlmeta:
> table = 'photos'
> time = IntCol()
> uri = UnicodeCol()
> description = UnicodeCol()
> roll_id = IntCol()
> default_version_id = IntCol()
> rating = IntCol()
> tags = SQLRelatedJoin('Tag',intermediateTable='photo_tags')
You can tell sqlobject which columns to use in the join using the
joinColumn and otherColumn keywords - this is mentioned in the FAQ,
although split across the descriptions of MultipleJoin and
RelatedJoin. So, something like:
tags =
SQLRelatedJoin('Tag',intermediateTable='photo_tags',otherColumn='tag_id',
joinColumn='photo_id')
and
photos =
SQLRelatedJoin('Photo',intermediateTable='photo_tags',otherColumn='photo_id',
joinColumn='tag_id')
--
Neil Muller
[EMAIL PROTECTED]
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
