hi there been pulling my hair out on this one for 2 days. i have two simple models. artist and tags.
and i have a artists_tags database table with artist_id and tag_id. artist model.... class Artist extends AppModel { var $name = 'Artist'; var $hasAndBelongsToMany = array( // 'Tag', 'Tag' => array( 'className' => 'Tag', 'joinTable' => 'artists_tags', 'foreignKey' => 'artist_id', 'associationForeignKey' => 'tag_id', 'unique' => true ) } tags model: class Tag extends AppModel { var $name = 'Tag'; var $hasAndBelongsToMany = 'Artist'; } i can read back values fine. which tells me my associations are working correctly. if i do a print_r($artist) i get: Array ( [0] => Array ( [id] => 793 [name] => ebm [link] => http://www.bob.com/tag/ebm [source] => 91 [rank] => [ArtistsTag] => Array ( [id] => 20 [artist_id] => 134426 [tag_id] => 793 ) ) ) the problem lies in writing the data. i am not using a form, but wanting to add data programatically. i fetch a whole lot of data from an API then process and insert. this method is working fine for all my HAS_MANY associations. so just trying to manually insert data here fails. it inserts the data into the tag model, but never populated the artist_tags table. if i try something like this: $artist = $this->Artist->findById(123456); $artist['Tag'][1]['name'] = "rock5"; $artist['Tag'][1]['link'] = "http://www.last.fm/tag/ebm"; $artist['Tag'][1]['artist_id'] = 184287; $artist['Tag'][1]['source'] = "Last.fm"; $artist['Tag'][1]['rank'] = 91; $this->Artist->Tag->save($artist['Tag'], false); or any other variations of save. no luck. // none of these work: //$this->Artist->Tag->saveAll($artist['Tag']); // $this->Tag->save($artist['Tag']); the sql trace is as follows: 45 INSERT INTO `tags` (`name`, `link`, `source`, `rank`) VALUES ('rock5', 'http://www.last.fm/tag/ebm', 'Last.fm', 91) 46 SELECT LAST_INSERT_ID() AS insertID 47 COMMIT 48 SELECT COUNT(*) AS `count` FROM `tags` AS `Tag` WHERE `Tag`.`id` = 842 49 START TRANSACTION any ideas, help or pointers would be much appreciated. -- 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php