Hi, I'm not sure whether this is a bug in sqlalchemy or user error. I'm having trouble passing a parameter to execute() that is a list of values for the in operator.
E.g.: session.execute(sql.text('SELECT * from users where x in :xs'), params={'xs' : some_seq}) This works fine when using MySQL so long as some_seq is a list of integers. It does not return the correct results if some_seq is a list of strings. It always fails with OperationalError when using sqlite. The in_ operator works correctly however my application needs to support text SQL input. Any ideas? Thanks. Jon. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---