Hello, What if there is a column that is called "state" When I try to add use_labels inside the execute statement I get below error. Should I be using the "use_labels" somewhere else?:
a[0].State Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/home/lucas/tmp/sql2008/env/lib/python2.5/site-packages/ SQLAlchemy-0.6.3-py2.5.egg/sqlalchemy/engine/base.py", line 1943, in __getattr__ return self[name] File "/home/lucas/tmp/sql2008/env/lib/python2.5/site-packages/ SQLAlchemy-0.6.3-py2.5.egg/sqlalchemy/engine/base.py", line 1934, in __getitem__ "try 'use_labels' option on select statement." % key) sqlalchemy.exc.InvalidRequestError: Ambiguous column name 'State' in result set! try 'use_labels' option on select statement. # -------unexpected keyword error a=session.execute("assp_ReportPolicyTransactions @start_date=:start, @end_date=:end",params={'start':"20100701",'end':"20100719"},use_labels=True).fetchall() Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/home/lucas/tmp/sql2008/env/lib/python2.5/site-packages/ SQLAlchemy-0.6.3-py2.5.egg/sqlalchemy/orm/session.py", line 732, in execute engine = self.get_bind(mapper, clause=clause, **kw) TypeError: get_bind() got an unexpected keyword argument 'use_labels' Thank you, Lucas -- 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.