there's no issue with underscore column names so something else must be going on.
On May 19, 2010, at 7:47 AM, mte wrote: > Hi, > I need to connect to an existing MS SQL database with SqlAlchemy. I'm > using a declarative_base (haven't tried with manual mapping) and it > seems to work except for a few fields. > Those are all defined as "col1 = > Column('some_field_with_underscores_in_name', AnyType)" > (AnyType meaning Integer, String or whatever else). > If I do a session.query(MyClass).first().col1 I get None returned. I > get the correct value if I do session.query(MyClass).first().col2 > (which doesn't have underscores in its name) or if I fetch the row > with session.execute("SELECT * FROM mytable"). > Can this be considered a bug or is there a setting I haven't specified > correctly? > > Thanks, > Matej > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@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. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@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.