the error youre showing me, which is "sqlalchemy.exc.OperationalError: (OperationalError) (1054, "Unknown column 'inside.foo' in 'on clause'") ", has nothing to do with mapping. the SQL is not being understood by the database. from_statement() results in the SQL you pass being executed verbatim, and the issue with the statement is what I said earlier.
On Apr 16, 2009, at 3:24 PM, dykang wrote: > > >> So above, you're joining "table2" to "s". the ON clause must be in >> terms of "table2" and "s", not "outside", which is meaningless in >> that >> context. > > You are correct, that was a mistake in my example, but does not change > my mapping error. > The error was not that the query it was creating was incorrect, but > that I was unable to map the results > back into my mapped classes. > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
