That worked like a charm - it didn't even occur to me to try that! I'm still getting used to this framework, and it's really cool to be able to do stuff like this.
Thanks for the assist! -Erich- AD7six wrote: > On Dec 11, 4:12 am, "Erich C. Beyrent" <[EMAIL PROTECTED]> > wrote: >> This insight is truly helpful, however, my associations are a little >> different. >> >> I have an Offer which belongs to a resort. A Resort belongs to both a >> State and a Destination, and hasMany Offers. Both States and >> Destinations hasMany Resorts. There is also a secondary association >> between Resorts and States where a Resort can be associated with many >> states. >> >> What I am trying to do is a findAll on my Specials, but have them >> grouped by Destination. > > So in other words you don't want a GROUP BY at all ;). > > // Use unbindModel to get rid of unneeded associations before running > // Use bindModel to define any associations or constraints on the > associated models. > $results = > $this->Offer->Resort->Destination->findAll($DestinationAndOrResortConstraint,null,'Destination.name > ASC',null,null,2); > pr ($results); die; > > That should get you a step closer. The array will of course be a > different structure from doing a find on offer, but the results will be > approx. what you are looking for. > > HTH, > > AD7six > Please note: > The manual/bakery is a good place to start any quest for info. > The cake search (at the time of writing) erroneously reports less/no > results for the google group. > The wiki may contain incorrect info - read at your own risk (it's > mainly user submitted) :) You may get your answer quicker by asking on > the IRC Channel (you can access it with just a browser > here:http://irc.cakephp.org). > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---