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-toand get > 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 -~----------~----~----~----~------~----~------~--~---
