Re: Help with queryset

2007-04-26 Thread [EMAIL PROTECTED]
Looks like I had overlooked isnull. Thanks guys. On Apr 24, 5:06 pm, robin_percy <[EMAIL PROTECTED]> wrote: > Looks like my earlier reply got dropped. Sorry if this ends up being > a double post. > > Check out the Model API > docs:http://www.djangoproject.com/documentation/db-api/#isnull > > Y

Re: Help with queryset

2007-04-24 Thread robin_percy
Looks like my earlier reply got dropped. Sorry if this ends up being a double post. Check out the Model API docs: http://www.djangoproject.com/documentation/db-api/#isnull You want to do something like: Year.objects.filter(event__isnull=False) - Robin On Apr 24, 11:15 am, "[EMAIL PROTECTED]"

Re: Help with queryset

2007-04-24 Thread robin_percy
Not a dumb question, but one that has been answered in the Django docs. Have a look at http://www.djangoproject.com/documentation/db-api/#isnull It sounds like you want: Year.objects.filter(event__isnull=False) - Robin On Apr 24, 11:15 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > I'll a

Re: Help with queryset

2007-04-24 Thread Tim Chase
> I have queryset=Year.objects.all() > > But I want to limit that years in which event is not Null. > > I'm assuming I want something like Year.objects.filter(event != Null) I presume you mean Year.objects.filter(event__isnull = False) which you can read about at http://djangoproject.com

Help with queryset

2007-04-24 Thread [EMAIL PROTECTED]
I'll apologize in advance, as I just know this is a dumb question... I have queryset=Year.objects.all() But I want to limit that years in which event is not Null. I'm assuming I want something like Year.objects.filter(event != Null) but I'm unsure about the syntax. --~--~-~--~~--

Re: help with queryset and ManytoMany

2007-02-02 Thread sandro.dentella
> > class Project > > ... > > staff = models.ManyToMany(User) > > > My concern is the fact that I should loop over all my projects and get > > the staff for each ot them. > > If Project has a ManyToMany field, then Users will have a field called > project_set. > > frank = User.objects.get

Re: help with queryset and ManytoMany

2007-02-01 Thread Russell Keith-Magee
On 2/1/07, Giorgio Salluzzo <[EMAIL PROTECTED]> wrote: > > class Project > ... > staff = models.ManyToMany(User) > > My concern is the fact that I should loop over all my projects and get > the staff for each ot them. If Project has a ManyToMany field, then Users will have a field called

help with queryset and ManytoMany

2007-02-01 Thread Giorgio Salluzzo
Hi all, Please, can you help me work out a queryset to get all the Users of all projects I belong to. from django.contrib.auth.models import User class Project ... staff = models.ManyToMany(User) My concern is the fact that I should loop over all my projects and get the staff for each