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