in_ is a method that exists on a column. You pass it the list of things that the column value should be in. For example, if you have a class called MyClass that is mapped to a table and has a column called id, you can do: session.query(MyClass).filter(MyClass.id.in_( [ 3, 4] )).all()
On Fri, May 9, 2008 at 10:35 AM, Googli S <[EMAIL PROTECTED]> wrote: > > Hello, > > I would like to use the IN construct in one of my queries: > > i.e. .... WHERE c.id IN (..subquery here) > > But I can't find any sqlalchemy support for It. It's hvery hard to > search for :( > > Anyone know? > > Thanks > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---