Re: [Sqlalchemy-users] problem with character '%s' in query

you probably want to use bind parameters: metadata.engine.execute(text("select * from test where url=:url"), url="http://bubu.com/%_20";) On Jul 19, 2006, at 12:19 PM, Gerhard Wohlgenannt wrote: > > hey everyone, > > > I ran into a "problem" (at least for me) with using sqlalchemy. >

[Sqlalchemy-users] problem with character '%s' in query

hey everyone, I ran into a "problem" (at least for me) with using sqlalchemy. The query: query = 'SELECT * FROM test WHERE url='http://bubu.com/%_20' metadata.engine.execute(query) raises an exception: File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py",