Thanks, Brandon. Somehow I missed that when I was perusing CPAN earlier. I am going to try out AdjacencyList.pm and see if it meets my needs. (I suspect it will.)
I'm glad I posted before I became too attached to my two-table structure. :) Mike On 5/24/07, Brandon Black <[EMAIL PROTECTED]> wrote:
In any case, if you really don't need multiple parents, you could switch back to just having a "parent_id" (or parent_category) field in "categories" (you'll need to define the FK separately with an ALTER TABLE statement probably), and use DBIx::Class::Tree::AdjacencyList from CPAN to make it work magically in DBIC. http://search.cpan.org/~bluefeet/DBIx-Class-Tree-0.01000/lib/DBIx/Class/Tree/AdjacencyList.pm
_______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
