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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
