Thanks to both: I felt I was missing something but couldn't find where to look :-)
Bob On Mar 19, 3:55 pm, Bill Freeman <ke1g...@gmail.com> wrote: > To expand on DR's answer slightly, the '=' in 'filter(crcWaarde=0)' is > not a comparison > operator. All arguments to filter need to be of the form > "'leagal_identifier'=value". This > is python syntax, nothing to do with django. Think of this '=' as > being more akin to > assignment. > > The answer to your problem is to use exclude instead of filter: > > ...get_query_set().exclude(ccWaarde=0) > > Bill > > On Fri, Mar 19, 2010 at 9:35 AM, Daniel Roseman <dan...@roseman.org.uk> wrote: > > On Mar 19, 1:22 pm, BobAalsma <b...@leaddevice.com> wrote: > >> In models.py, when I use > >> class GevondenManager(models.Manager): > >> def get_query_set(self): > >> return > >> super(GevondenManager,self).get_query_set().filter(crcWaarde > >> = 0) > >> I get proper answers. > > >> However, I want to filter on "not equal to" and this does not seem to > >> work. How to proceed? > > >> I have tried > >> class GevondenManager(models.Manager): > >> def get_query_set(self): > >> return > >> super(GevondenManager,self).get_query_set().filter(crcWaarde > >> <> 0) > > >> as well as > >> class GevondenManager(models.Manager): > >> def get_query_set(self): > >> return > >> super(GevondenManager,self).get_query_set().filter(crcWaarde ! > >> = 0) > > >> and in both cases the results seem the same: > > <snip> > >> NameError: global name 'crcWaarde' is not defined > > > This needs to be a standard filter expression. So you use the normal > > Django query filter syntax as documented here: > >http://docs.djangoproject.com/en/1.1/topics/db/queries/#retrieving-sp... > > > Don't forget these are *parameters to a function*, not expressions in > > themselves. So in your case you need: > > return > > super(GevondenManager,self).get_query_set().exclude(crcWaarde=0) > > -- > > DR. > > > -- > > You received this message because you are subscribed to the Google Groups > > "Django users" group. > > To post to this group, send email to django-us...@googlegroups.com. > > To unsubscribe from this group, send email to > > django-users+unsubscr...@googlegroups.com. > > For more options, visit this group > > athttp://groups.google.com/group/django-users?hl=en. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
