Hi! Can somebody point me why this fails?
>>> meta = MetaData(bind="sqlite:///:memory:") >>> blocks = Table('blocks', meta, ... Column('id', Integer, primary_key=True, autoincrement=True), ... Column('lines', Integer), ... Column('lastline', Integer), ... ) >>> blocks.create() >>> blocks.update().execute(lines = blocks.c.lines + 1) Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.10-py2.5.egg/sqlalchemy/sql.py", line 1207, in execute return self.compile(bind=self.bind, parameters=compile_params).execute(*multiparams, **params) File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.10-py2.5.egg/sqlalchemy/sql.py", line 1097, in execute return e.execute_compiled(self, *multiparams, **params) File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.10-py2.5.egg/sqlalchemy/engine/base.py", line 780, in execute_compiled return connection.execute_compiled(compiled, *multiparams, **params) File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.10-py2.5.egg/sqlalchemy/engine/base.py", line 568, in execute_compiled self._execute_raw(context) File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.10-py2.5.egg/sqlalchemy/engine/base.py", line 581, in _execute_raw self._execute(context) File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.10-py2.5.egg/sqlalchemy/engine/base.py", line 599, in _execute raise exceptions.SQLError(context.statement, context.parameters, e) sqlalchemy.exceptions.SQLError: (InterfaceError) Error binding parameter 0 - probably unsupported type. u'UPDATE blocks SET lines=blocks.lines + ?' [<sqlalchemy.sql._BinaryExpression object at 0x847e20c>] Seems like a bug, but may be I'm doing something wrong? -- Paul. --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---