No idea really, not without seeing all three models and the query that is being generated.
Regards, Langdon rtanz wrote: > thnx langdon, i took that relationship out however the query is still > returning 0 results. I am using recursive 3 so it should be able to > retrieve two levels down. any other ideas why this is not working? tnx > > On Aug 15, 1:47 am, Langdon Stevenson <[EMAIL PROTECTED]> > wrote: >> Hi rtanz >> >> In your query you don't need to specify the relationship: >> >> AND Membership.role_id = TaskTemplate.role_id >> >> If you have this relation defined between the Membership, Role, and Task >> models, then Cake will retrieve the related data for you (assuming you >> allow it to retrieve related data two levels down). >> >> Just select the Membership that you want and Cake will do the rest. >> >> If for some reason this produces too many queries for your liking, >> Google the "expects()" function to help unbind unneeded models, or as a >> last resort run the query from MySQL using $this->ModelName->query(); >> >> Regards, >> Langdon >> >> rtanz wrote: >>> hi i am having problems obtaining results for a query through cakephp, >>> i posted the relevant code in this link >>> http://bin.cakephp.org/view/1874003220 >>> note that the first part is the query as constructed through the mysql >>> query builder which correctly returns the results, while the second >>> part is what i did through cake, which is not returning any results. >>> thanks for any help > > > > --~--~---------~--~----~------------~-------~--~----~ 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?hl=en -~----------~----~----~----~------~----~------~--~---
