Hi
I'm experiencing something unexpected with a containable within a
find('first') - here's my code:
$this->data = $this->Mixture->MixtureCategory->find('first', array(
'conditions'=>array('MixtureCategory.slug'=>$slug,
'MixtureCategory.status'=>1),
'recursive'=>2,
'contain'=>array(
'BannerImage',
'Mixture'=>array('BannerImage',
'conditions'=>array('Mixture.status'=>1)),
'ParentMixtureCategory'=>array('BannerImage'),
'ChildMixtureCategory'=>array('BannerImage',
'Mixture'=>array('conditions'=>array('Mixture.status'=>1)))
)
));
This outputs a few queries, one of which is:
SELECT `BannerImage`.`id`, `BannerImage`.`document_category_id`,
`BannerImage`.`model`, `BannerImage`.`foreign_key`,
`BannerImage`.`name`, `BannerImage`.`description`,
`BannerImage`.`meta_title`, `BannerImage`.`meta_keywords`,
`BannerImage`.`meta_description`, `BannerImage`.`extension`,
`BannerImage`.`mime_type`, `BannerImage`.`filesize`,
`BannerImage`.`md5`, `BannerImage`.`allow_delete`,
`BannerImage`.`status`, `BannerImage`.`created`,
`BannerImage`.`modified`, `BannerImagesMixtureCategory`.`id`,
`BannerImagesMixtureCategory`.`mixture_category_id`,
`BannerImagesMixtureCategory`.`document_id` FROM `documents` AS
`BannerImage` JOIN `banner_images_mixture_categories` AS
`BannerImagesMixtureCategory` ON
(`BannerImagesMixtureCategory`.`mixture_category_id` = 5 AND
`BannerImagesMixtureCategory`.`document_id` = `BannerImage`.`id`)
WHERE 1 = 1
This shows no records found in the SQL log - but when i run the exact
query above in phpmyadmin the record i expect is found.
Any ideas?
Thanks,
Jon
--
jon bennett
w: http://www.jben.net/
iChat (AIM): jbendotnet Skype: jon-bennett
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" 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
-~----------~----~----~----~------~----~------~--~---
