[sqlalchemy] Re: Doubt in forming a dynamic query
On May 5, 2008, at 9:10 AM, Roopesh wrote: How can I do something like: table2.c.domain in ['naukri.com', 'gmail.com', 'yahoo.com'] Also how can I do something like table2.c.domain not in ['naukri.com', 'gmail.com', 'yahoo.com'] use the in_ method, column.in_(['naukri.com', 'gmail.com', 'yahoo.com']), not_(column.in_(['naukri.com', 'gmail.com', 'yahoo.com'])) . --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[sqlalchemy] Re: Doubt in forming a dynamic query
use the in_ method, column.in_(['naukri.com', 'gmail.com', 'yahoo.com']), not_(column.in_(['naukri.com', 'gmail.com', 'yahoo.com'])) . But when I do this, I am getting an error as follows: not_(msg_headers.c.email_domain.in_['naukri.com','yahoo.com','hotmail.com']), TypeError: 'instancemethod' object is unsubscriptable Thanks and Regards Roopesh --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[sqlalchemy] Re: Doubt in forming a dynamic query
On Tuesday 06 May 2008 07:40:36 Roopesh wrote: use the in_ method, column.in_(['naukri.com', 'gmail.com', 'yahoo.com']), not_(column.in_(['naukri.com', 'gmail.com', 'yahoo.com'])) . But when I do this, I am getting an error as follows: not_(msg_headers.c.email_domain.in_['naukri.com','yahoo.com','hotma il.com']), TypeError: 'instancemethod' object is unsubscriptable well... read /copy _more_ carefuly? not_( msg_headers.c.email_domain.in_( ['naukri.com','yahoo.com','hotmail.com'] ) ) --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---