Some problem on the hasmany relationship

Hi,

I am facing some problem when deal with a realtionship tables, the
record is not display :

// in Stock model:
var $hasAndBelongsToMany = array(
'Category' => array(
'className' => 'Category',
'joinTable' => 'category',
'foreignKey' => 'stock_id',
'associationForeignKey' => category_id',
'with' => 'StockCategory',
),
);

// in Stock controller:
$selectedRecord = $this->Stock->StockCategory->find('list',
array( 'fields'=>array('stock_id','category_id'),
'conditions'=>array('stock_id='.$this->Stock->id) ) );
$this->set(compact('selectedRecord'));

I try to copy the SQL by using debug() to phpmysql, and i get 3 lines
of records. but when i try to PRINT_R the $selectedRecord, i can only
get 1 record, example:

Array
(
[1] => 4
)

Suppose the result have to be :

Array
(
[1] => 4
[1] => 7
[1] => 14
)

Values : 4,7,14 are category_id, [1] is stock_id. There is a table
call "category" to store all the category name.

Please point out whats wrong to my code or logic??

Thanks

Best Regards.

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php