On Mon, Apr 30, 2007 at 06:54:09PM -0300, Claudio Martinez wrote: > http://paste.turbogears.org/paste/1248 > function is here http://paste.turbogears.org/paste/1249 > http://paste.turbogears.org/paste/1250 > http://paste.turbogears.org/paste/1251
Sorry, I am not going to look at all this. Please simplify things down to a script of a dozen of lines. One or two tables are usually enough to demonstrate the problem. And of course use only SQLObject. I don't use and don't know TurboGears. > For some reason the alias tables are getting inner and left joined, so I'm > getting this error: > > OperationalError: ambiguous column name: customer_person.id Either you have to rewrite JOINs so that the table mentioned once in the query or use aliases. Oleg. -- Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss