I think you want to look in the manual under Developing with CakePHP > Models > Retrieving your Data > find.
http://manual.cakephp.org/view/449/find Then look at Developing with CakePHP > Controllers > Controller Methods > Interacting with Views > set http://manual.cakephp.org/view/427/set You should never edit the actual Cake libraries unless you are developing CakePHP itself. On Jul 13, 6:51 pm, PaulMan <[EMAIL PROTECTED]> wrote: > Done.. where's how: > New version of: class Event extends AppModel > { > var $name = 'Event'; > var $displayField= 'description'; > var $belongsTo=array('Pool','Result' => array( > 'className' => 'Result', > 'conditions' => 'Result.is_final=1' > )); > > } > > New Version of scaffold.php on line 311 > foreach ($this->ScaffoldModel->belongsTo as $assocName => $assocData) > { > $varName = > Inflector::variable(Inflector::pluralize(preg_replace('/ > _id$/', '', $assocData['foreignKey']))); > $this->controller->set($varName, > $this->ScaffoldModel->{$assocName}->find('list',$assocData)); > > } > foreach ($this->ScaffoldModel->hasAndBelongsToMany as > $assocName => > $assocData) { > $varName = > Inflector::variable(Inflector::pluralize($assocName)); > $this->controller->set($varName, > $this->ScaffoldModel->{$assocName}->find('list',$assocData)); > > } > > this way i can use params defined on var $belongsTo or > hasAndBelongsToMany ... > > now the problem is... is this going to "f***" all the rest or is a > good hack? > > On 13 Jul, 17:28, PaulMan <[EMAIL PROTECTED]> wrr ote: > > > thank's for the quick reply, > > i already had read that articles, but i did no found the solution, the > > problem is on the "Edit" action for events, that's where i want to > > filter results, so that the final user can select a restrict options > > of results. > > Or maybe the solution is there and i'm too "newbie" blind to see, ??? > > if this is true please , sorry. > > > lets put in another way: > > take a look at the debug query bellow , at Nr 8 i would like to have > > 8 SELECT `Result`.`id`, `Result`.`description` FROM `results` AS > > `Result` WHERE Result.is_active = 1 7 7 0 > > > so this way on the edit action , Results select box will be only > > populated with Results that are active, not all of them. > > > since i'm with scaffold , is this possible? > > > Nr Query Error Affected Num. rows Took (ms) > > 1 DESCRIBE `events` 8 8 2 > > 2 DESCRIBE `pools` 10 10 2 > > 3 DESCRIBE `results` 6 6 2 > > 4 DESCRIBE `bets` 6 6 2 > > 5 DESCRIBE `users` 10 10 2 > > 6 SELECT COUNT(*) AS `count` FROM `events` AS `Event` WHERE > > `Event`.`id` = 1 1 1 1 > > 7 SELECT `Event`.`id`, `Event`.`pool_id`, `Event`.`result_id`, > > `Event`.`description`, `Event`.`comment`, `Event`.`date`, > > `Event`.`created`, `Event`.`modified`, `Result`.`id`, > > `Result`.`is_final`, `Result`.`description`, `Result`.`value`, > > `Result`.`created`, `Result`.`modified`, `Pool`.`id`, > > `Pool`.`description`, `Pool`.`comment`, `Pool`.`number`, `Pool`.`open > > date`, `Pool`.`close date`, `Pool`.`active`, `Pool`.`season`, > > `Pool`.`created`, `Pool`.`modified` FROM `events` AS `Event` LEFT JOIN > > `results` AS `Result` ON (`Result`.`is_final`=1 AND > > `Event`.`result_id` = `Result`.`id`) LEFT JOIN `pools` AS `Pool` ON > > (`Event`.`pool_id` = `Pool`.`id`) WHERE `Event`.`id` = 1 LIMIT 1 > > 1 1 > > 1 > > 8 SELECT `Result`.`id`, `Result`.`description` FROM `results` AS > > `Result` WHERE 1 = 1 7 7 0 > > 9 SELECT `Pool`.`id`, `Pool`.`description` FROM `pools` AS `Pool` > > WHERE 1 = 1 > > > On 13 Jul, 16:36, "Dardo Sordi Bogado" <[EMAIL PROTECTED]> wrote: > > > > Perhaps you should start reading > > > here:http://book.cakephp.org/view/78/associations-linking-models-toandget > > > a grasp of models relations and how to specify conditions. Then you > > > can use bakehttp://book.cakephp.org/view/113/code-generation-with-bake > > > to materialize the scaffold code and start coding the application > > > logic > > > > On Sun, Jul 13, 2008 at 12:18 PM, PaulMan <[EMAIL PROTECTED]> wrote: > > > > > Hello Everyone, > > > > Using Scaffold, > > > > I Have a Model "Event" that belongsTo Result. > > > > The Problem is when i edit an Event How can i filter Results so that > > > > only rows ( Records ) with a especific condition, like > > > > Result.is_final=1, are available for select. > > > > > class EventsController extends AppController { > > > > var $name = 'Events'; > > > > var $components=array("auth"); > > > > var $scaffold; > > > > } > > > > > class Event extends AppModel > > > > { > > > > var $name = 'Event'; > > > > var $displayField= 'description'; > > > > var $belongsTo=array('Pool','Result' => array( > > > > 'className' => 'Result', > > > > 'foreignKey' => 'result_id' > > > > )); > > > > > } --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
