acts_as_tree related question

hi,
I've a normal Category model implemented with acts_as_tree (name,
parent_id) that has_many :products (name, category_id).

What I'm asking for is a method to fetch every product that belongs
fall into a particular category and its children, eg: if I'm asking
for a root node (/category/show/1) I need to display every product
that have category_id = 1 AND every product of the children
categories.

After that I must paginate results, search, but that's really another
story.

Somebody got an advice how to accomplish this?

thanks.

shai,
thanks for your kind reply, yes, I've evaluated the use of tags for
categorisation, but for now I really must stick with Category trees;
I've also looked into acts_as_nested_set (and the better_nested_set
one), but honestly I've found some difficulties to manage Category in
this way.

what I really need is some input using acts_as_nested_set: eg. an
example controller (to manage items) and the real problem: fetch every
product in selected category and subcategories.

any hints on that?

thanks again.

claudio

what about #all_children in BNS

http://opensource.symetrie.com/api/better_nested_set/classes/SymetrieCom/Acts/NestedSet/InstanceMethods.html#M000023