On Thu, Apr 09, 2009 at 11:44:52PM +0200, Hanjie wrote:
> class postTable(SQLObject):
> title = UnicodeCol(length=50)
> content = UnicodeCol()
> comments=MultipleJoin('commentTable')
>
> class commentTable(SQLObject):
> post=ForeignKey('postTable')
> authorName=UnicodeCol(length=255,notNull=False)
> content=UnicodeCol()
>
> But, when I want to use q.comment, the error arise:
> OperationalError: Unknown column 'post_table_id' in 'where clause'
The problem lies here:
class postTable(SQLObject):
comments=MultipleJoin('commentTable')
class commentTable(SQLObject):
post=ForeignKey('postTable')
There are simply too many different names: 'comments', 'commentTable',
'post' and 'postTable'. Multitude of these names confuses SQLObject so it
doesn't know how to count comments of a post. One can help SQLObject by
explicitly naming the column in the other table:
class postTable(SQLObject):
comments=MultipleJoin('commentTable', joinColumn='post_id')
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ p...@phd.pp.ru
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
