HABTM problem

[Ace]

I have standard users table. Every user can have many accounts
(account is a group of permissions, like a role) and every account can
be linked to many users. Relation is HABTM as you can see. When I
call:

$accounts=$this->User->find('first', array('conditions' => array
('User.user_id' => 1)));

i get:

Array ( [User] => Array ( [user_id] => 1 [contact_name] =>
Administrator [email_address] => t...@test.pl [username] => root
[password] => 7a89a595cfcjeb85480202a143e37d2e [language] => pl
[default_account_id] => 2 [comments] => [active] => 1 [sso_user_id] =>
[date_created] => 2009-08-13 18:45:50 [date_last_login] => 2009-08-17
14:33:27 [email_updated] => 2009-08-13 18:45:50 ) [Account] => Array
( ) )

Account array is empty. SQL generated by cake doesn't even mention
accounts or account_user_assoc table:

        SELECT `User`.`user_id`, `User`.`contact_name`,
`User`.`email_address`, `User`.`username`, `User`.`password`,
`User`.`language`, `User`.`default_account_id`, `User`.`comments`,
`User`.`active`, `User`.`sso_user_id`, `User`.`date_created`,
`User`.`date_last_login`, `User`.`email_updated` FROM `ox2_users` AS
`User` WHERE `User`.`user_id` = 1 LIMIT 1

Can anyone help me with this?

My User model code:

class User extends AppModel {
    var $name = 'User';
    var $recursive=1;
     var $hasAndBelongsToMany = array(
 'Account' =>
        array(
 'className' => 'Account',
 'joinTable' => 'account_user_assoc',
             'foreignKey' => 'user_id',
 'associationForeignKey' => 'account_id',
'unique' => true
        )
    );
    function hashPasswords($data){
        $data['User']['password']=md5($data['User']['password']);
        return $data;
    }

}

Account model code:

class Account extends AppModel {
    var $name = 'Account';
    var $primaryKey = 'account_id';
}




--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to 
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---