Hi ,
I'm new to SQLObject so my question would be probably stupid... ;)

I'm trying to do a foreign key to the same table but I've got an error


Here's an example:

class NestedTest(SQLObject):
     attr1 = StringCol()
     attr2 = StringCol()
     parent = ForeignKey('NestedTest')
#NestedTest.createTable()
NestedTest.sqlmeta.addJoin(MultipleJoin('NestedTest',joinMethodName='childs'))

n1=NestedTest(attr1='first', attr2='55408',parent=None)
n2=NestedTest(attr1='second', attr2='55409', parent=n1)
n3=NestedTest(attr1='third', attr2='55410', parent=n1)


print n2.childs



TRACEBACK#######################
Traceback (most recent call last):
  File "/Applications/eclipse/plugins/org.python.pydev.debug_1.3.17/pysrc/pydevd.py", line 852, in <module>
    debugger.run(setup['file'], None, None)
  File "/Applications/eclipse/plugins/org.python.pydev.debug_1.3.17/pysrc/pydevd.py", line 689, in run
    execfile(file, globals, locals) #execute the script
  File "/Users/dimiduj/Sites/Sites/pythonProjects/ackobots/src/sqlO/__init__.py", line 49, in <module>
    print n1.childs
  File "<string>", line 1, in <lambda>
  File "/Library/Frameworks/Python.framework/Versions/2.5/lib/python2.5/site-packages/SQLObject-0.10.1-py2.5.egg/sqlobject/joins.py", line 144, in performJoin
    inst.id)
  File "/Library/Frameworks/Python.framework/Versions/2.5/lib/python2.5/site-packages/SQLObject-0.10.1-py2.5.egg/sqlobject/dbconnection.py", line 537, in _SO_selectJoin
    self.sqlrepr(value)))
  File "/Library/Frameworks/Python.framework/Versions/2.5/lib/python2.5/site-packages/SQLObject-0.10.1-py2.5.egg/sqlobject/dbconnection.py", line 350, in queryAll
    return self._runWithConnection(self._queryAll, s)
  File "/Library/Frameworks/Python.framework/Versions/2.5/lib/python2.5/site-packages/SQLObject-0.10.1-py2.5.egg/sqlobject/dbconnection.py", line 250, in _runWithConnection
    val = meth(conn, *args)
  File "/Library/Frameworks/Python.framework/Versions/2.5/lib/python2.5/site-packages/SQLObject-0.10.1-py2.5.egg/sqlobject/dbconnection.py", line 343, in _queryAll
    self._executeRetry(conn, c, s)
  File "/Library/Frameworks/Python.framework/Versions/2.5/lib/python2.5/site-packages/SQLObject-0.10.1-py2.5.egg/sqlobject/mysql/mysqlconnection.py", line 119, in _executeRetry
    raise OperationalError(ErrorMessage(e))
sqlobject.dberrors.OperationalError: Unknown column 'nested_test_id' in 'where clause'
Exception exceptions.AttributeError: "'NoneType' object has no attribute 'print_exc'" in <function _removeReceiver at 0x12214f0> ignored


#####################################

I've seen these two thread :
But there is no clear answer

What I'm doing wrong ?
Is this impossible with SQLObject?
Any help would be appreciate

Thx

Dimitri