Well i know that with HABTM it will always need a table to define the relations. However with "normal" sql you can just write one query to select across the different tables. For example with the tags you can select on the tag name and the post title and whatever more you want.
With the Cake way you can only select on the id of foreignkey. If you wanted to select on the tag name you with first query the tags with that name, put them in a array and then you can query the articles you want. So it does not really make code shorter and i assume that performance will decrease too since you doing 2 queries. On Aug 29, 5:53 pm, "Chris Hartjes" <[EMAIL PROTECTED]> wrote: > On 8/29/07, Mech7 <[EMAIL PROTECTED]> wrote: > > > The HABTM lets you do things like Posts and Tags where a post can have > many different tags and tags can be applited to multiple posts. You > need a join table no matter what for that type of relationship, and > the ability to automatically have that associated data appear in my > result set with only one or two lines of code is a huge productivity > increase. > > -- > Chris Hartjes > Senior Developer > Cake Development Corporation > > My motto for 2007: "Just build it, damnit!" > > @TheBallpark -http://www.littlehart.net/attheballpark > @TheKeyboard -http://www.littlehart.net/atthekeyboard --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
