[sqlalchemy] Re: Doubt in forming a dynamic query

2008-05-05 Thread Michael Bayer


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

2008-05-05 Thread Roopesh

 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

2008-05-05 Thread az

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
-~--~~~~--~~--~--~---