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