It's $actsAs, not $actAs. Jeremy Burns Class Outfit
[email protected] http://www.classoutfit.com On 28 Jan 2011, at 08:41, raymond 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 > [email protected] For more options, visit this group at > http://groups.google.com/group/cake-php -- 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 [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
