Hi, I'm attempting to make a search page with the following tables:
Chapter belongsTo Book Book HABTM Author Chapter HABTM Author I'm creating the search page in the Chapters model. I want to be able to search for chapters which belong to a book that has a particular author (through the Book HABTM Author relation). Setting the recursive property to 2 isn't an option as it pulls back far to much data (80 queries for a page load in some of the worst cases) and doesn't reach far enough to get to the Author table. Any suggestions on how I could make this work without doing a custom query? Thanks Will --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
