Yep I got it working with bind/unbind. Defining all the associations in the model before hand is nice "clean", but inefficient on the find since it will return all data for all associations.
It would be interesting to be able to define a few associations in the model and be able to pass the association name to the find methods. Thanks anselm wrote:
> Quick description of the domain/model... > > Working on a newsletter for a record shop... > > Models: Newsletter, Releases, Formats > > - Newsletter hasMany Releases > - Released belongsTo Formats > > So basically a newsletter will display the new releases for the week > and each release has a format such as: CD, Tape, Vinyl etc... > > Now I would like to split, the newsletter to only display all new > releases on Vinyl format on the front page and the others on separate > pages. > > How would I do this? Bind, unbind? If you look in the chapter about associations (http://manual.cakephp.org/chapter/models), you can see that an association can have a name that is different from the classname -- that allows you to have different associations for the same table. For each of the association you can then use the 'conditions' field to set conditions particular to this association. So for instance you have two associations in your NewsLetter model, one for the vinyls and one for the other types : var $hasMany = array( 'VinylReleases' => array( 'className' => 'Release', 'conditions' => 'Release.type = "vinyl"' ), 'NonVinylReleases' => array( 'className' => 'Release', 'conditions' => 'Release.type <> "vinyl"' ) ); Now when you call $this->NewsLetter->find(...); This should return an array containing a field 'VinylReleases' and another field 'NonVinylReleases' with the correct data in it. You can add other terms to that condition -- it's SQL -- so you could add an extra condition to get only the releases of a certain time period. If this needs to be done on the fly, then, yes, use bind/unbind. Anselm
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
