i guess s.execute(stmt, params=dict(codeword=codeword) )

}On Friday 13 February 2009 18:42:26 Max Ischenko wrote:
> I get an error when I'm trying tu run this:
>
>             stmt = text("""select * from salary_data_new
>                 where codeword=:codeword union
>                  select * from salary_data_clean where
> codeword=:codeword """)
>             # s is instance of Session() class factory
>             c.rec = s.execute(stmt, codeword=codeword).fetchone()
>
> I get:
> File
> '/home/max/projects/site-baseline/doupy/doupy/controllers/salarydb.
>py', line 420 in record
>   c.rec = s.execute(stmt, codeword=codeword).fetchone()
> File
> '/home/max/projects/site-baseline/py/lib/python2.5/site-packages/SQ
>LAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/session.py', line 752 in
> execute
>   engine = self.get_bind(mapper, clause=clause, **kw)
> TypeError: get_bind() got an unexpected keyword argument 'codeword'
>
> What am I doing wrong?



--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to