no, cake can easily build the join that you need:
http://teknoid.wordpress.com/2008/07/17/forcing-an-sql-join-in-cakephp/
as matter of fact there is an example like like this one in the
manual. and i must've posted this link on the list a bunch of times.
so searching is always a good idea...
On Oct 31, 6:06 pm, Ita <[EMAIL PROTECTED]> wrote:
> Well since no shiny knight in white armor came to my rescue I wound up
> creating my query.
> I guess cake has its own limitations.
>
> On Oct 30, 7:41 am, Ita <[EMAIL PROTECTED]> wrote:
>
> > So it just can't handle the conditions?
> > What should I do in this case? create my own query?
>
> > On Oct 29, 7:29 pm, teknoid <[EMAIL PROTECTED]> wrote:
>
> > > cake does not create joins for hasMany (only hasOne and belongsTo)
>
> > > On Oct 29, 12:27 pm, Ita <[EMAIL PROTECTED]> wrote:
>
> > > > Hi,
> > > > I have 2 models Item and Defect.
> > > > both of them have description.
> > > > an Item can have many Defects and my defects table has a an item_id
> > > > field.
>
> > > > Now I'm trying to create a search query that will search both the item
> > > > description and the defect description.
> > > > What I do is this:
>
> > > > $this->Item->bindModel(
> > > > array('hasMany' => array(
> > > > 'Defect' => array(
> > > > 'className' => 'Defect',
> > > > 'foreignKey' => 'item_id',
> > > > 'type' => 'INNER'
> > > > )
> > > > )
> > > > )
> > > > );
> > > > then I run findAll.
>
> > > > Now when I use findAll with no conditions everything works fine. cake
> > > > seems to run 2 queries:
> > > > SELECT `Item`.`id`,...... FROM `items` AS `Item` WHERE 1 = 1
> > > > SELECT `Defect`.`id`,.......... FROM `defects` AS `Defect` WHERE
> > > > `Defect`.`item_id` IN (1, 2, 16, 15, 14, 13, 12, 11, 10, 17, 18, 19,
> > > > 20)
>
> > > > My first question is why does cake doesn't create one query with INNER
> > > > JOIN?
> > > > The second problem is when I add conditions:
> > > > $conditions[] = "`Item`.`name` LIKE '%" .$search_term ."%' OR
> > > > `Defect`.`description` LIKE '%" . $search_term . "%'";
>
> > > > It seems that cake in this case ignores the join all together and just
> > > > does a regular select so I get an error:
> > > > 1054: Unknown column 'Defect.description' in 'where clause'
>
> > > > Does anyone know what I'm doing wrong?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
