Similarly, if I am doing an order_by: query = Session.query(SmartdataEligibilityRecord).order_by(SmartdataEligibilityRecord.member.middle_initial.desc()).all()
It returns: Error - <type 'exceptions.AttributeError'>: Neither 'InstrumentedAttribute' object nor 'Comparator' object has an attribute 'middle_initial' In this kind of circumstance of joined tables, in the python code itself (the Pylons controller, actually) how would I refer to the member table's middle_initial field where the members table is joined in with a left outer join via SQLAlchemy? Thanks again -RVince -- 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.