Unfortunately cake created that query and even know it's incorrect.

It should probably be comparing it with contest_id=Contest.id

But, I am just giving up on it...:((

On 8/28/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:

I don't think the ON for the join is right. What is the significance of

ON `contests_profiles`.`contest_id` = '1'
AND `contests_profiles`.`profile_id` = `Profile`.`id`  ?

The comparison with 1 does not make any sense to me in the context of
an ON condition. Did cake create that query, or did you?

Ralph






--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake PHP" 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
-~----------~----~----~----~------~----~------~--~---

Reply via email to