hi
still not able to solve the problem..can someone help
Regards,
bingo
On Apr 7, 2:13 pm, "bingo" <[EMAIL PROTECTED]> wrote:
> hi,
>
> I have a table with following structure
>
> posts_keywords:
> post_id
> keyword_id
> created
>
> I am trying to find coocurring keywords for this I created a
> association like this
>
> var $belongsTo = array(
> 'Coocurrence' =>
> array('className' => 'PostsKeyword',
> 'foreignKey' => 'post_id',
> 'associationForeignKey' => 'post_id',
> 'conditions' => '',
> 'fields' => 'PostsKeyword.keyword_id, Coocurrence.keyword_id'
> )
> );
>
> However, cakephp ignores my specifications for associationForeignKey
> and fields and the final SQL is this
>
> SELECT PostsKeyword.post_id, PostsKeyword.keyword_id, Posts.created,
> Coocurrence.post_id, Coocurrence.keyword_id, Coocurrence.created FROM
> `posts_keywords` AS `PostsKeyword` LEFT JOIN `posts_keywords` AS
> `Coocurrence` ON `PostsKeyword`.`post_id` = `Coocurrence`.`id`
>
> where this should be
> left join ............on . 'PostsKeyword'.'post_id' =
> 'Coocurrence'.'post_id'
>
> I am not sure what's the problem
>
> Regards,
> bingo
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
