Does this mean that 1.2 still can't filter a result set by a related
model over habtm?
I've been trying to filter my Links by Category to no avail today.
Link habtm Category
Category habtm Link
$this->set('links', $this->paginate('Link', array('Category.id'=>$this-
>data['Link']['category_id'])));
Which fails because CakePHP won't join the related model in the query.
Will I be reduced to creating a Model for the join CategoriesLink and
then writing my own query to grab data from it? It seems determined to
do two separate queries.
The only other way I could think of, which I haven't tried yet, was to
use /category/5/$link_id which might work, but I assumed would suffer
the same fate in the sql of missing a join. Or should I be making an
on-the-fly bind using a belongsTo association to force the join, which
would then pickup my conditions?
I have read the CakeBaker article (http://cakebaker.42dh.com/
2007/10/17/pagination-of-data-from-a-habtm-relationship/), but that
looks to be for 1.1 as my existing habtm works for reading and saving,
but not for when you want to adjust the resultset using a field from
the related model.
Idea's or links would be appreciated!
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
