I hope you can post your database , I think you are not wrong in configuring , but It difficult to answer you if you don't post database and say more about your achivement
2009/3/19 Pete Bekisz <[email protected]> > Hi all, > > I'm having some problems with saving HABTM relationships, and I was hoping > you could help me. The two models in question are Registrant and Product. > > In my Registrant model, I have a method that builds an array that looks > like this: > > Array > ( > [Registrant] => Array > ( > [id] => 133 > ) > > [Product] => Array > ( > [0] => Array > ( > [product_id] => 1 > [quantity] => 5 > [cost] => 25.00 > ) > > [1] => Array > ( > [product_id] => 2 > [quantity] => 1 > [cost] => 8.50 > [option_id] => 13 > ) > > [2] => Array > ( > [product_id] => 2 > [quantity] => 9 > [cost] => 76.50 > [option_id] => 14 > ) > > [3] => Array > ( > [product_id] => 2 > [quantity] => 3 > [cost] => 25.50 > [option_id] => 15 > ) > > ) > > ) > > When I try using $this->saveAll($array) it does nothing, and when I try using > $this->Product->saveAll($array), this is the SQL it runs: > > 44START TRANSACTION0045SELECT `ProductsRegistrant`.`registrant_id` FROM > `products_registrants` AS `ProductsRegistrant` WHERE > `ProductsRegistrant`.`product_id` = ''11046DELETE `ProductsRegistrant` FROM > `products_registrants` AS `ProductsRegistrant` WHERE > `ProductsRegistrant`.`product_id` = '' AND > `ProductsRegistrant`.`registrant_id` = (130)1047INSERT INTO > `products_registrants` (`product_id`,`registrant_id`) VALUES > ('','133')1048COMMIT > > I've been playing with this for quite a while and I can't figure out what's > wrong. Could someone offer some guidance, please? > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
