(TurboGears 0.8a5)

given the following model (using sqlite):

class Task(SQLObject):
    name = StringCol(length=50, notNull=True)
    category = ForeignKey('TaskCategory')

class TaskCategory(SQLObject):
    name = StringCol(length=50, notNull=True)
    tasks = MultipleJoin('Task')

this gives me an error:

>>> t = TaskCategory.select()[0]
>>> t.tasks
OperationalError: no such column: task_category_id

I checked the database that was created and the "task" table has a
"category_id" column for the foreign key.
I guess I'm confused about the relationship between the variable name
and the string parameter in the ForeignKey definition.  Any insight is
appreciated.

-- 
DaveS

Reply via email to