[Catalyst] Retrieve all users belong to a category and all its sub categories

Charlie Garrison garrison at zeta.org.au
Thu Dec 16 23:36:07 GMT 2010


Good morning,

On 16/12/10 at 11:15 AM -0500, Hauck, William B. 
<William.Hauck at ibx.com> wrote:

>Not sure how to do it in a DBIC-like fashion, but these few 
>links show you how to do it in SQL for PostgreSQL and MySQL.  
>Oracle and DB2 have hierarchical functionality built-in.
>
>http://www.postgresql.org/docs/8.4/static/queries-with.html
>
>http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
>
>http://onlamp.com/lpt/a/5007

I haven't been following this thread closely, but I think one of 
the DBIC::Tree modules is what OP is looking for:

<http://search.cpan.org/perldoc?DBIx::Class::Tree::AdjacencyList>
<http://search.cpan.org/perldoc?DBIx::Class::Tree::NestedSet>


Charlie

-- 
    Ꮚ Charlie Garrison ♊ <garrison at zeta.org.au>

O< ascii ribbon campaign - stop html mail - www.asciiribbon.org
〠  http://www.ietf.org/rfc/rfc1855.txt



More information about the Catalyst mailing list