OK, I switched to Tree::NestedSet.<br><br>Can someone give me real example, its not working for me.<br><br>Thanks<br><br><div class="gmail_quote">On Fri, Dec 17, 2010 at 8:22 PM, will trillich <span dir="ltr"><<a href="mailto:will.trillich@serensoft.com">will.trillich@serensoft.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"></lurk><div><br></div><div>Ooh, I didn't know about either of those. Very, very sweet! And one for nested-sets and another for parent-links/adjacency lists.</div>
<div><br></div><div>This is what's so great about open source mailing lists -- the serendipity. Here on a Catalyst web-framework list you learn cool, tangential things about DBIC that you didn't know you were missing, and then you can just go nab new tools that make life easy!</div>
<div><br></div><div>Awesome.</div><div><br></div><div><div><div></div><div class="h5"><br><div class="gmail_quote">On Thu, Dec 16, 2010 at 11:36 PM, Charlie Garrison <span dir="ltr"><<a href="mailto:garrison@zeta.org.au" target="_blank">garrison@zeta.org.au</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Good morning,<div><br>
<br>
On 16/12/10 at 11:15 AM -0500, Hauck, William B. <<a href="mailto:William.Hauck@ibx.com" target="_blank">William.Hauck@ibx.com</a>> wrote:<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
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.<br>
<br>
<a href="http://www.postgresql.org/docs/8.4/static/queries-with.html" target="_blank">http://www.postgresql.org/docs/8.4/static/queries-with.html</a><br>
<br>
<a href="http://dev.mysql.com/tech-resources/articles/hierarchical-data.html" target="_blank">http://dev.mysql.com/tech-resources/articles/hierarchical-data.html</a><br>
<br>
<a href="http://onlamp.com/lpt/a/5007" target="_blank">http://onlamp.com/lpt/a/5007</a><br>
</blockquote>
<br></div>
I haven't been following this thread closely, but I think one of the DBIC::Tree modules is what OP is looking for:<br>
<br>
<<a href="http://search.cpan.org/perldoc?DBIx::Class::Tree::AdjacencyList" target="_blank">http://search.cpan.org/perldoc?DBIx::Class::Tree::AdjacencyList</a>><br>
<<a href="http://search.cpan.org/perldoc?DBIx::Class::Tree::NestedSet" target="_blank">http://search.cpan.org/perldoc?DBIx::Class::Tree::NestedSet</a>><br>
<br>
<br>
Charlie<br><font color="#888888">
<br>
-- <br>
Ꮚ Charlie Garrison ♊ <<a href="mailto:garrison@zeta.org.au" target="_blank">garrison@zeta.org.au</a>><br>
<br>
O< ascii ribbon campaign - stop html mail - <a href="http://www.asciiribbon.org" target="_blank">www.asciiribbon.org</a><br>
〠 <a href="http://www.ietf.org/rfc/rfc1855.txt" target="_blank">http://www.ietf.org/rfc/rfc1855.txt</a></font><div><div></div><div><br>
<br>
_______________________________________________<br>
List: <a href="mailto:Catalyst@lists.scsys.co.uk" target="_blank">Catalyst@lists.scsys.co.uk</a><br>
Listinfo: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst" target="_blank">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst</a><br>
Searchable archive: <a href="http://www.mail-archive.com/catalyst@lists.scsys.co.uk/" target="_blank">http://www.mail-archive.com/catalyst@lists.scsys.co.uk/</a><br>
Dev site: <a href="http://dev.catalyst.perl.org/" target="_blank">http://dev.catalyst.perl.org/</a><br>
</div></div></blockquote></div><br><br clear="all"><br></div></div>-- <br>Failure is not important. How you overcome it, is.<br>-- Nick Vujicic<br>
</div>
<br>_______________________________________________<br>
List: <a href="mailto:Catalyst@lists.scsys.co.uk">Catalyst@lists.scsys.co.uk</a><br>
Listinfo: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst" target="_blank">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst</a><br>
Searchable archive: <a href="http://www.mail-archive.com/catalyst@lists.scsys.co.uk/" target="_blank">http://www.mail-archive.com/catalyst@lists.scsys.co.uk/</a><br>
Dev site: <a href="http://dev.catalyst.perl.org/" target="_blank">http://dev.catalyst.perl.org/</a><br>
<br></blockquote></div><br>