Expanding percent signs when no args available

[Former user]

In 19: con Out19: Engine(mysql://login:passwd@localhost:3306/db)

In 20: con.execute("SELECT name FROM names WHERE name LIKE '%name%'")

<type 'exceptions.TypeError'> Traceback (most recent call last)

/home/stromnov/BLOGS/CORBA/controller/src/blogs-trunk/auxiliary/<ipython console> in <module>()

/var/lib/python-support/python2.5/sqlalchemy/engine/base.py in execute(self, statement, multiparams, params) 1200 def execute(self, statement, multiparams, params): 1201 connection = self.contextual_connect(close_with_result=True) -> 1202 return connection.execute(statement, *multiparams, params) 1203 1204 def scalar(self, statement, multiparams, *params):

/var/lib/python-support/python2.5/sqlalchemy/engine/base.py in execute(self, object, multiparams, *params) 822 for c in type(object).mro: 823 if c in Connection.executors: --> 824 return Connection.executorsc(self, object, multiparams, params) 825 else: 826 raise exc.InvalidRequestError("Unexecutable object type: " + str(type(object)))

/var/lib/python-support/python2.5/sqlalchemy/engine/base.py in _execute_text(self, statement, multiparams, params) 886 parameters = self.__distill_params(multiparams, params) 887 context = self.__create_execution_context(statement=statement, parameters=parameters) --> 888 return self.__execute_context(context) 889 890 def __execute_context(self, context):

/var/lib/python-support/python2.5/sqlalchemy/engine/base.py in __execute_context(self, context) 894 self._cursor_executemany(context.cursor, context.statement, context.parameters, context=context) 895 else: --> 896 self._cursor_execute(context.cursor, context.statement, context.parameters0, context=context) 897 if context.compiled: 898 context.post_exec()

/var/lib/python-support/python2.5/sqlalchemy/engine/base.py in _cursor_execute(self, cursor, statement, parameters, context) 946 self.engine.logger.info(repr(parameters)) 947 try: --> 948 self.dialect.do_execute(cursor, statement, parameters, context=context) 949 except Exception, e: 950 self._handle_dbapi_exception(e, statement, parameters, cursor, context)

/var/lib/python-support/python2.5/sqlalchemy/engine/default.py in do_execute(self, cursor, statement, parameters, context) 120 121 def do_execute(self, cursor, statement, parameters, context=None): --> 122 cursor.execute(statement, parameters) 123 124 def is_disconnect(self, e):

/var/lib/python-support/python2.5/MySQLdb/cursors.py in execute(self, query, args) 149 query = query.encode(charset) 150 if args is not None: --> 151 query = query % db.literal(args) 152 try: 153 r = self._query(query)

<type 'exceptions.TypeError'>: not enough arguments for format string

PS. args = () at this point

[Mike Bayer]

that's raw SQL - escape your percent signs %% per MySQLdb usage.