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
-~----------~----~----~----~------~----~------~--~---

Reply via email to