Thats a subquery - and while the newer mysql4.1 and above now supports
subqueries - cakephp uses a left inner join by default - if you want
the speed and performance of the subquery youll have to use
$this->ModelName->query("the SQL string");
otherwise read the manual/api on setting up query conditions and let
cake build it with the join
On Aug 6, 4:04 pm, Langdon Stevenson <[EMAIL PROTECTED]> wrote:
> Hi Peter
>
> > I would appreciate someone pointing me to a reference which explains
> > how to code something like this in CakePHP:
>
> The "conditions" section of the manual (in the Models page from memory)
> covers the creation of complex conditions in queries. I don't see
> anything in your query that Cake can't handle.
>
> If there is a problem, you could also just use
>
> $this->ModelName->query("the SQL string");
>
> To run the query that you posted, this is not recommended though.
>
> Regards,
> Langdon
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
