I think you need to use Q objects, which can be OR'd together http://www.djangoproject.com/documentation/db-api/#complex-lookups-with-q-objects
Or you could just write your own SQL (http://www.djangoproject.com/ documentation/db-api/#falling-back-to-raw-sql) On Dec 13, 6:00 pm, Kent Johnson <[EMAIL PROTECTED]> wrote: > Doug B wrote: > > I think you want filter's evil twin exclude: > > I know about exclude() but I don't see how to use it here. > > I want s1==1 OR s2!=1, so for example records (s1=1, s2=1) and (s1=2, > s2=2) would be accepted. > > filter(s1=1).exclude(s2=1) is s1==1 AND s2!=1; it will not retrieve > either of the above examples. > > Kent --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" 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/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
