Re: how to use self join in cake

2008-07-19 Thread gerhardsletten
Thanks, this what I was looking for. Works nice with var $actsAs = array('Tree'); to --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com

Re: how to use self join in cake

2008-07-15 Thread Siegfried Hirsch
Did you take a look to this posting in the bakery ? http://bakery.cakephp.org/articles/view/coding-a-self-join-in-a-cake-application On Tue, Jul 15, 2008 at 10:01 AM, kaushik <[EMAIL PROTECTED]> wrote: > I want to introduce the parentID in this Model, this parentId is > actually foreign key to l

how to use self join in cake

2008-07-15 Thread kaushik
I am new in CakePHP. I am facing problem to use parent_id of category table. Here is my code details: categories Table: `categoryId` int(10) NOT NULL auto_increment, `categoryName` varchar(100) NOT NULL, `parentId` int(10) NOT NULL default 0, `isActive` enum('Y','N') NOT NULL default 'Y',