On 10/23/05, SZEKERES Istvan <[EMAIL PROTECTED]> wrote: > Now how can I select all the restaurants that belong to a category and are > in a given city? > > To get the restaurants from a city I can do: > r = restaurants.get_list (city__id__exact=n) > > To get the restaurants belonging to a specific category I can do: > r = category.get_restaurant_list() > > But is there a way to combine them? Comparing the results of the two > queries to find the common items is not very optimal... I'm looking for > something like > > r = restaurants.get_list(city__id__exact=n, categories__contain=category)
Hey Pistahh, Try this: restaurants.get_list(city__id__exact=n, categories__id__exact=3) (Assuming you want category 3.) Adrian -- Adrian Holovaty holovaty.com | djangoproject.com | chicagocrime.org
