je viens de modifier mon action admin_edit()
je me suis debarassé de l'index 'id' dans $this->data dans le cas d'un ajout
voilà mon $this->data
Array
(
[Annonce] => Array
(
[category_id] => 1
[title] => Vente Studio
[description] => jhsvd,b,sdvsdqsd
[date_begin] =>
[date_end] =>
[published] => 0
[user_id] => 1
)
[Caractere] => Array
(
[0] => Array
(
[id] => 2
[values] => aze
)
[1] => Array
(
[id] => 8
[values] => rty
)
[2] => Array
(
[id] => 5
[values] => uio
)
[3] => Array
(
[id] => 7
[values] => pqs
)
)
et voilà ce que j'ai en SQL quand je fais un save();
15 INSERT INTO `annonces`
(`category_id`,`title`,`description`,`date_begin`,`date_end`,`published`,`user_id`,`modified`,`created`)
VALUES (1,'Vente Studio','jhsvd,b,sdvsdqsd','','','0',1,'2008-07-18
15:49:26','2008-07-18 15:49:26') 1 12
16 SELECT LAST_INSERT_ID() AS insertID 1 1 0
17 SELECT `AnnoncesCaractere`.`annonce_id` FROM `annonces_caracteres` AS
`AnnoncesCaractere` WHERE `AnnoncesCaractere`.`annonce_id` = 88 0
0 0
18 SELECT COUNT(*) AS `count` FROM `annonces_caracteres` AS
`AnnoncesCaractere` WHERE `AnnoncesCaractere`.`annonce_id` = 88 1
1 0
19 INSERT INTO `annonces_caracteres` (`values`,`annonce_id`) VALUES
('aze',88) 1 0
20 SELECT COUNT(*) AS `count` FROM `annonces_caracteres` AS
`AnnoncesCaractere` WHERE `AnnoncesCaractere`.`annonce_id` = 88 1
1 0
21 UPDATE `annonces_caracteres` SET `values` = 'rty', `annonce_id` = 88
WHERE `annonces_caracteres`.`annonce_id` = 88 1 0
22 SELECT COUNT(*) AS `count` FROM `annonces_caracteres` AS
`AnnoncesCaractere` WHERE `AnnoncesCaractere`.`annonce_id` = 88 1
1 0
23 UPDATE `annonces_caracteres` SET `values` = 'uio', `annonce_id` = 88
WHERE `annonces_caracteres`.`annonce_id` = 88 1 0
24 SELECT COUNT(*) AS `count` FROM `annonces_caracteres` AS
`AnnoncesCaractere` WHERE `AnnoncesCaractere`.`annonce_id` = 88 1
1 0
25 UPDATE `annonces_caracteres` SET `values` = 'pqs', `annonce_id` = 88
WHERE `annonces_caracteres`.`annonce_id` = 88
Cake fait toujours un insert et le reste c'est des update
--~--~---------~--~----~------------~-------~--~----~
Groupe "Cakephp-fr".
Adresse : [email protected]
Pour résilier : [EMAIL PROTECTED]
Pour les options : http://groups.google.com/group/cakephp-fr?hl=fr
-~----------~----~----~----~------~----~------~--~---
