Re: Cakephp query have all conditions in join

[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 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 benefits?
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---

Re: Cakephp query have all conditions in join

[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 benefits?
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---

Cakephp query have all conditions in join

[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 it and if there's a way to disable it

--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---

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

[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();


--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---