Hi, I am trying to use a column property, I have a class Foo:
class Foo(object): pass which is mapped to a table foo_table and it has multiple names which are stored in bar_table with foo_id as the primary key in Foo and ForeignKey in bar_table. I am trying to use a column property to access these: mapper(Foo, foo_table, properties={ "names" : column_property(select([bar_table.c.name], bar_table.c.foo_id == foo_table.c.foo_id).label("names")) } ) so when I try to query any of the objects I just get no results back, but when I try it without the column property I get something back. Am I just doing something incredibly stupid wrong? Many thanks in advance, Nathan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---