On Mar 27, 10:50 am, "space_boy" <[EMAIL PROTECTED]> wrote: > In the 'Complex Find Conditions (using arrays)' section of the Models > chapter in the manual (http://manual.cakephp.org/chapter/models), it > is suggested that you can search multiple models using a conditions > array such as: > > array > ("Author.name" => "Bob", "or" => array > ( > "Post.title" => "LIKE %magic%", > "Post.created" => "> " . date('Y-m-d', strtotime("-2 weeks") > ) > ) > > which would find all the posts that contain a certain keyword or that > were created in the past two weeks, but were written by Bob. > > I am trying to apply this example to two models that are associated by > a HABTM relationship (i.e. Post and Tag), so that I can search for > posts that were created after a certain date, that are also tagged > with some keyword. > > i.e. my conditions array looks like: > array > ( > "Tag.name" = "LIKE %magic%", > "Post.created" => "> " . date('Y-m-d', strtotime("-2 weeks") > ) > > However, when I execute $this->Post->findAll() using this conditions > array from my posts_controller, I receive an error saying 'SQL Error > in model Post: 1054: Unknown column 'Tag.name' in 'where clause'', > after examining the SQL that is generated by Cake it is clear that the > tags table isn't being referenced at all by the query. > > Have I missed something here? Are these kinds of complex find > conditions expected to work for HABTM models? > > Thanks.
To answer my own question, I've found this open Trac ticket which addresses this issue: https://trac.cakephp.org/ticket/1209 looks like it's currently slotted for 1.2 release. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---