Hi, I am getting an error when adding {$__cakeID__$} variable to my finderQuery. If I replace that variable with a hard coded number then it works fine, any ideas what the problem could be? It has me a bit baffled.
'finderQuery' => "SELECT `product_attributes_products`.`value`, `ProductAttribute`.`id`, `ProductAttribute`.`name`, `ProductAttribute`.`desc`, `ProductAttribute`.`created_by`, `ProductAttribute`.`created`, `ProductAttribute`.`modified_by`, `ProductAttribute`.`modified` FROM `product_attributes` AS `ProductAttribute` JOIN `product_attributes_products` ON `product_attributes_products`.`product_id` = {$__cakeID__$} AND `product_attributes_products`.`product_attribute_id` = `ProductAttribute`.`id` WHERE 1 = 1" This is the error message: Parse error: parse error, unexpected '"' Help would be appreciated Thanks Mike --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---