Re: Tree behavior does not work!!!

It's $actsAs, not $actAs.

Jeremy Burns

Class Outfit

jeremyburns@classoutfit.com

http://www.classoutfit.com

On 28 Jan 2011, at 09:00, Raymond Chester wrote:

Hi, everyone. This is second time to post with this kind of content to this group. My first time post was gone, never appears, and dunno why, so I m writing the post again.  I just used Tree behavior for category, according to what cakePHP manual said. But when I used generatetreelist(), it all  times says following:  Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'generatetreelist' at line 1 [CORE\cake\libs \model\datasources\dbo_source.php, line 684] ... $sql	=	"generatetreelist" $error	=	"1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'generatetreelist' at line 1" $out	=	null ... msController::category() - APP\controllers\items_controller.php, line 12 ... Query: generatetreelist  I found that the system actually does not recorgnize what generatetreelist() is, but do not know what to do...  I created table called lkp_itemcate with following fields: id, parent_id, lft, rght, name, img_url, level, created, modified  And made Model class following: class Itemcate extends AppModel { 	var $name = 'Itemcate'; 	var $tablePrefix = 'lkp_'; 	var $useTable = 'itemcate';  	var $actAs = array('Tree'); }  and then used generatetreelist() in controller:  class ItemsController extends AppController { 	var $name = 'Items'; 	var $modelClass = 'Itemcate'; 	var $uses = array('Itemcate');  	function category($act = 'index', $id = null) { 		... 		$list = $this->Itemcate->generatetreelist(null, null, null, '   ');                 ...         }         ... }  Please help me to settle with this issue. I really can not find what s wrong, googled for 2 hours, but never find such a case like mine. Best regards, Raymond. 

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
 
 
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php