[sqlalchemy] Re: Adding additional conditions to an outer join

= People.query.add_column(PersonRoles.role_status).from_statement(stmt) print people.all() [(User(admin,Admin User), u'approved'), (User(public,Public Man), None), (User(toshio,Toshio Kuratomi), u'approved')] Thanks to Bobby and Kipb for the various parts of this solution! -Toshio signature.asc

[sqlalchemy] polymorphic problem in 0.3.5

Hi guys. I'm using sqlalchemy with TurboGears. The code for my project is GPL, so if you need access to more source just let me know: I was successfully using the following definition of a polymorphic_union in 0.3.4:: ''' collectionJoin = polymorphic_union ( {'b' :

[sqlalchemy] Re: polymorphic problem in 0.3.5

On Wed, 2007-03-21 at 16:11 -0400, Michael Bayer wrote: the literal('c') compiles into a bind parameter, which is not able to export itself as a column on its enclosing selectable, so thats that error (i might want to look into adding a better error for that one, had never seen it