Re: Model Association Query....stumped
I've done the following: Clipranking Model: function findClipByRank($site_id){ return $this-query(SELECT Clipranking.rank, Clipranking.site_id, Clipranking.required, Clip.id, Clip.name, Clip.length FROM cliprankings AS Clipranking, clips AS Clip WHERE Clipranking.site_id = $site_id AND Clipranking.clip_id = Clip.id); } And calling in my controller works fine: $clip = $this-Site- Clipranking-findClipByRank($id); In my short experience with Cake, it seems that there would be a more Cake-ish way to accomplish this. I'm a noob here so, it's probably obvious. Thanks, Jeremy --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Model Association Query....stumped
All - I've been using Mariano Iglesias Bindable behavior with 1.2 beta to nice effect, but I've run into a query I can't figure out. Here's what I have: Team hasMany Clip Team hasMany Site Site hasMany Clipranking A Site can play any of the Clips available in their Team in whatever ranked order they wish. The Clipranking table contains a field 'rank' and 'clip_id'. Clipranking and Clip are not related (at least not now...). In my Sites controller I want to retrieve all the Cliprankings and get the Clip data that corresponds to the 'clip_id'. I can't seem to get a query or on the fly BindModel() that will get me what I want. I guess I'm obtuse. I've never done a HBTM relationship before, and maybe that's what I need? I'm open to any suggestions or noob sledgehammering for not seeing it. Much obliged, Jeremy --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---