Have you searched the group? I know AD7 has posted about this topic before. :)
http://groups.google.com/group/cake-php/browse_thread/thread/f23b1825050ad543/014092749592de70?lnk=gst&q=habtm+search&rnum=3#014092749592de70 On Mar 20, 9:13 am, "Cake In The Face" <[EMAIL PROTECTED]> wrote: > Need a solution to this too. > > On Mar 7, 6:38 am, "FredsFriend" <[EMAIL PROTECTED]> wrote: > > > > > Hey > > I've had a bit of a nosey around and can't seem to find the answer to > > my problem. > > I have two tables ( cars, products) and a join table ( cars_products) > > all set up with a HABTM relationship using bake.php. > > I want to be able to return a set of results from products that are > > related to a particular car and also filtered by another field in > > products. > > > $the code that i'm using is: > > > $conditions = array ( 'Car.id' => $carId, > > 'Product.category_id' => $categoryId ); > > $this->set ( 'productList', $this->Product->findAll ( $conditions ) ); > > > which just outputs "SQL Error in model Product: 1109: Unknown table > > 'Car' in where clause" > > I have tried it the other way around and i just get warned that > > Product is an unknown table. I'm sure I am missing something as this > > is a fairly simple query to do with pure SQL- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
