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
-~----------~----~----~----~------~----~------~--~---
