On Mon, 2007-03-05 at 18:12 +0530, Kenneth Gonsalves wrote: > hi, > > I have two models: > > Child(models.Model): > name = CharField > .... > > Sponsorship(models.Model): > name = CharField > child = ForeignKey(Child) > ... > > how do i get a list of all children who are not in Sponsorship?
I'm pretty sure you can't do this at the moment with only the Django query functionality. You are going to have to drop down to some SQL wrangling. It's come up in previous threads, though, so might be worth a quick search through the archives. The reason it doesn't work, from memory, is because the obvious attempts like querying on sponsorship__child__isnull = True does not generate an SQL query that will work -- you simply don't get rows in the result where there is no link between Child and Sponsorship. We would have to special case this particular type of query construction, which rapidly gets messy (detecting it in all the ways it can occur, for a start). Regards, Malcolm --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
