Re: Cakephp query have all conditions in join

2008-03-28 Thread c3k
UP http://groups.google.com/group/cake-php/browse_thread/thread/7ca543c3832c075b/e271da3dad4b2e98 On 5 Mar, 16:18, c3k <[EMAIL PROTECTED]> wrote: > On 5 Mar, 13:32, AD7six <[EMAIL PROTECTED]> wrote: > > > Based on what logic would you like cake to ignore the condition

Re: Cakephp query have all conditions in join

2008-03-05 Thread c3k
On 5 Mar, 13:32, AD7six <[EMAIL PROTECTED]> wrote: > Based on what logic would you like cake to ignore the conditions you > are explicitly telling it to restrict your results on. I expect that my conditions are used in the where, why they are used in the where AND in the join??? Which are the

Cakephp query have all conditions in join

2008-03-05 Thread c3k
Someone can explain me why cakephp when make joins use all the condition passed for the query? I've see this behavior from the beginning and i didn't worry about it, but today i've found a query on a big table that is slowing down my app because of the join condition. I'd like to know more about

Complex Find Conditions with "sound like" OR soundex()

2007-04-24 Thread c3k
in a model, how can I create a condition array that generate an sql query like: SELECT * FROM dbo.Orders WHERE SOUNDEX(ShipName) = SOUNDEX('ernest') OR SELECT * FROM dbo.Orders WHERE ShipName SOUNDS LIKE 'ernest' ??? Is there a way whitout have to use $model->query(); --~--~-~--~--