/lurk
Ooh, I didn't know about either of those. Very, very sweet! And one for
nested-sets and another for parent-links/adjacency lists.
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
OK, I switched to Tree::NestedSet.
Can someone give me real example, its not working for me.
Thanks
On Fri, Dec 17, 2010 at 8:22 PM, will trillich
will.trill...@serensoft.comwrote:
/lurk
Ooh, I didn't know about either of those. Very, very sweet! And one for
nested-sets and another for
Thanks, it worked.
But how to do it If I have sub categories of sub category?
Example is below.
id name parent _id
1 cat10
2 cat21
3 cat3 0
4 cat4 2
5 cat5 4
Here, I have cat1 cat2 - cat4
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
Good morning,
On 16/12/10 at 11:15 AM -0500, Hauck, William B.
william.ha...@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.
Le 09/12/2010 09:37, linuxsupport a écrit :
I have 3 tables, users, user_cat, and cat, table structure and
relationship are setup as follows.
User.pm
__PACKAGE__-add_columns(
id, { data_type = integer, is_nullable = 0 },
username,{ data_type = text, is_nullable = 1 },
password, {
I have 3 tables, users, user_cat, and cat, table structure and relationship
are setup as follows.
User.pm
__PACKAGE__-add_columns(
id,
{ data_type = integer, is_nullable = 0 },
username,
{ data_type = text, is_nullable = 1 },
password,
{ data_type = text, is_nullable = 1 },
On Thu, Dec 9, 2010 at 9:37 AM, linuxsupport lin.supp...@gmail.com wrote:
I have 3 tables, users, user_cat, and cat, table structure and relationship
are setup as follows.
User.pm
__PACKAGE__-add_columns(
id,
{ data_type = integer, is_nullable = 0 },
username,
{ data_type = text,