On Wed, 2007-12-05 at 15:34 -0800, globophobe wrote: > I've read the documentation. I admit to being more than a little > deficient with databases. Can anybody suggest a better way? > > if len(study) < 20: > exclude = user.study_set.filter(stack=stack).values('card') > cards = stack.card_set.exclude(id__in=[i.get('card') for i in > exclude])[:20-len(study)]
Probably an easier question to answer if we could see the models involved (and perhaps an English description of what you are wanting to achieve). My gut feeling is that this is either as simple as you get or else it should be possible to fold the exclude directly into the "cards" queryset without having to do an explicit extra query. Which alternative is possible depends on your model relationships. Regards, Malcolm -- Quantum mechanics: the dreams stuff is made of. http://www.pointy-stick.com/blog/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---