Re: SQL Error: 1054 - Join query between 3 tables - HABM / dynamic binding

Thanks. It is only one feature per product.

I removed hasOne association from 'Product' table

I already have the foreign key in the 'Product' table 'feature_id' for
which I have hasOne association in the 'Feature' table.

I still get the same error:

$sql = "SELECT `Feature1`.`id`, `Feature1`.`name`,
`Feature1`.`description`, ... FROM `features` AS `Feature1` WHERE
`Feature1`.`id`=`Product`.`feature_id` "
$error = "1054: Unknown column 'Product.feature_id' in 'where clause'"
$out = null

I could just get 'all' and foreach it through while filtering
everything, but I trust there is a way to do this smartly with find()
in cakephp. Thanks.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---