Rails - Mar 2006 - Find non-empty association?

I have two models, Category and Article.  Article belongs_to :category
and Category has_many :articles.  I''d like to be able to find all
non-empty categories.  What''s the best way to do that?

Pat

Am Mittwoch, den 01.03.2006, 04:14 -0700 schrieb Pat
Maddox:
> I have two models, Category and Article.  Article belongs_to :category
> and Category has_many :articles.  I''d like to be able to find all
> non-empty categories.  What''s the best way to do that?
Category.find(
  :all,
  :include => :articles,
  :conditions => ''articles.category_id IS NOT NULL''
)

I think this might be the right clause. But i am not 100% sure.

-- 
Norman Timmler

http://blog.inlet-media.de

On 3/1/06, Norman Timmler <lists@inlet-media.de>
wrote:
> Am Mittwoch, den 01.03.2006, 04:14 -0700 schrieb Pat Maddox:
> > I have two models, Category and Article.  Article belongs_to :category
> > and Category has_many :articles.  I''d like to be able to find
all
> > non-empty categories.  What''s the best way to do that?
>
> Category.find(
>   :all,
>   :include => :articles,
>   :conditions => ''articles.category_id IS NOT NULL''
> )
>
> I think this might be the right clause. But i am not 100% sure.
>
> --
> Norman Timmler
>
> http://blog.inlet-media.de
>
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>
Thanks for the code bit.  Unfortunately I''m not sure if it works,
because I''m using HABTM.  Of course it was late and didn''t ask
the
proper question..but is there a nice way to do it for a HABTM?

Pat