Re: django db api: looking for "not-in select

2006-10-04 Thread RajeshD
Use exclude instead of filter: http://www.djangoproject.com/documentation/db_api/#exclude-kwargs --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-user

django db api: looking for "not-in select

2006-10-04 Thread Ulrich Nitsche
hi, in the docs I found a method to run a query like this: MyObj.objects.filter(id__in=[1, 3, 4]). My question is if there is a "negative" to this like the following raw sql "SELECT xxx FROM mytable WHERE xxx NOT IN (1, 2 ,4);" Is there any hint in the docs that I missed? Thanks uli _