"select col1, col2, col3 from assp_reportpolicytransactions ...."
otherwise the SP has to be made such that distinct column names are produced. I'm not familiar with MS-SQL's syntax there. On Jul 22, 2010, at 3:33 PM, Lukasz Szybalski wrote: > 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. > -- 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.