[SQLObject] self join

[Culley H. <har...@gm...>]

Hi,

I am trying to model a self join and having trouble.  Say we have a
table called node with two columns:  id, parent_id.  So we have a
class:

class Node(SQLObject):
    parent = ForeignKey('node')
    children = MultipleJoin('node', joinColumn='parentID')

The childrens reference is invalid.  How do I do this?

culley