Hello all, I've decided to try the example from documentation explaining HABTM association.
I had setup posts, tags and posts_tags and proper association. But documentation doesn't explain the main thing: how to save NEW post with the NEW tags, not listed in the multiple select, but in the input separated by comma, for example? What I did: in the Post model: function beforeSave() { $this->data['Tag']['Tag'] = explode(",", $this->data['Tag'] ['Tag']); // making array of tags from input field $this->data['Post']['user_id'] =$this->user['id']; // current user id return true; } Then, after saveing Post Cake produces following queries: 7 INSERT INTO `posts` (`category_id`,`title`,`content`,`user_id`,`created`,`modified`) VALUES ('4','title3','text3','4','2007-01-30 14:23:31','2007-01-30 14:23:31') 1 1 8 DELETE FROM `posts_tags` WHERE post_id = '6' 0 0 9 INSERT INTO `posts_tags` (post_id,tag_id) VALUES ('6','tag1') 1 0 10 INSERT INTO `posts_tags` (post_id,tag_id) VALUES ('6','tag2') 1062: Duplicate entry '6-0' for key 1 0 11 INSERT INTO `posts_tags` (post_id,tag_id) VALUES ('6','tag3') 1062: Duplicate entry '6-0' for key 1 1 Queries 9,10,11 are completely wrong. It must save first tags into Tags, and THEN IDs into Posts_Tags. But it trying to save tags into posts_tags :-/ (tag1,tag2,tag3 - are tags, not ids) Of course I can do this stuff without associations using only query() function, but I want to do it Cake-way. Please help! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---