Hello I'm trying to use finderQuery for a hasMany relationship between tables in cake to get Ratings automatically when I view an Entry.. anyhow, I use this:
var $hasMany = array ( 'WikiRating' => array ( 'className' => 'WikiRating', 'foreignKey' => 'entry_id', 'dependent' => true, 'exclusive' => true, 'finderQuery' => 'SELECT ( SELECT count(*) FROM wiki_ratings AS WikiRating WHERE WikiRating.entry_id = {$__cakeID__$} ) AS num_votes, AVG(WikiRating.rating) AS avg_rating FROM wiki_ratings AS WikiRating WHERE WikiRating.entry_id = {$__cakeID__$} LIMIT 1' ) ); but am getting an odd error which causes an error in dbo_source: Notice: Undefined index: WikiRatings in c:\documents and settings\morris\Desktop\houseparty_alpha\alpha_build_svn\web\cake\libs\model\datasources\dbo_source.php on line 709 Notice: Undefined index: WikiRatings in c:\documents and settings\morris\Desktop\houseparty_alpha\alpha_build_svn\web\cake\libs\model\datasources\dbo_source.php on line 716 After a closer look, it seems like the query is executing OK but the result it is getting is [0][0][num_votes] and [0][0][avg_rating]... which when merging cake doesnt like, since it is looking for [0][ModelName][...] etc.. SO, I'm wondering if any of you may have run into something like this, or know how I can force my result to work as cake wants it. Thanks! --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---