Worked perfectly! I looked at "$this->ModelName->query("the SQL
string");" in the manual but didn't try it! Thanks both of you for you
help.
Peter -
On Aug 6, 8:58 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
