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.

Reply via email to