hi AD,
I just noticed...that CakePHP is ignoring my field specification and
is pickuping all the fields from SelfJoinOnArticles
so the returned data array is
[39] => Array
(
[ArticlesKeywordsUser] => Array
(
[article_id] => 698
)
[SelfJoinOnArticle] => Array
(
[article_id] => 96
[id] => 166
[keyword_id] => 89
[user_id] => 2
[created] => 2007-02-28
)
[0] => Array
(
[nos] => 1
)
)
where as based on the fields specification it should be
[39] => Array
(
[ArticlesKeywordsUser] => Array
(
[article_id] => 698
)
[SelfJoinOnArticle] => Array
(
[article_id] => 96
)
[0] => Array
(
[nos] => 1
)
)
regards,
ritesh
On Apr 12, 7:59 am, "bingo" <[EMAIL PROTECTED]> wrote:
> Hi AD
>
> cool..that works..great...
>
> however, I am not sure why associationForeignKey does not work. I
> checked the model class and it seems associationForeignKey is never
> loaded for belongsTo...is that an error or this query I am trying to
> specify is exceptional..
>
> n'ways..thank you for suggestion..
>
> Regards,
> Ritesh
>
> On Apr 12, 7:44 am, "AD7six" <[EMAIL PROTECTED]> wrote:
>
>
>
> > On 12 abr, 13:35, "bingo" <[EMAIL PROTECTED]> wrote:
>
> > > Hi,
>
> > > I am trying to specify this self join + groub by query (see below my
> > > query example). However, I am not joining the table on id but on
> > > another field.
>
> > > select ArticlesKeywordsUser.article_id, SelfJoinOnArticle.article_id,
> > > count(*) as nos from articles_keywords_users as ArticlesKeywordsUser
> > > leftJoin articles_keywords_users as SelfJoinOnArticle where
> > > ArticlesKeywordsUser.article_id = SelfJoinOnArticle.article_id group
> > > by ArticlesKeywordsUser.keyword_id, SelfJoinOnArticle.keyword_id
>
> > > To do this, I defined my model as follows
>
> > > class ArticlesKeywordsUser extends AppModel{
> > > var $name = 'ArticlesKeywordsUser';
>
> > > var $belongsTo = array(
> > > 'SelfJoinOnKeyword' => array(
> > > 'className' => 'ArticlesKeywordsUser',
> > > 'foreignKey' => 'article_id',
> > > 'associationForeignKey' => 'article_id'
> > > )
>
> > > );
>
> > > }
>
> > > and in my controller I am specifying the query like this
>
> > > $this->{$this->modelClass}->expects('SelfJoinOnArticle');
> > > $this->{$this->modelClass}->findAll('1 = 1 group by
> > > ArticlesKeywordsUser.keyword_id, SelfJoinOnArticle.keyword_id',
> > > 'ArticlesKeywordsUser.article_id, SelfJoinOnArticle.article_id,
> > > count(*) as nos')
>
> > > However the final query produced by CakePHP is not what I intented.
> > > Everything works as I thought, but instead of join on article_id it
> > > does ArticlesKeywordsUser.article_id = SelfJoinOnArticle.id --- which
> > > I dont want
>
> > I wouldn't expect associationForeignKey to be even looked at for a
> > belongsTo.
>
> > just cheat,
>
> > do $this->Article->primaryKey = 'article_id'; before you call the
> > find.
>
> > If that doesn't work or give an idea how to get it to work, an
> > indication of your table structure would be useful.
>
> > hth,
>
> > AD- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
