Hi,
Good idea. It doesn't show any warnings, though.
And it only shows one INSERT statements as being executed, yet 3
records are still created.
--------
1 DESC `applicants` 32 32 0
2 DESC `divisions` 2 2 0
3 DESC `statuses` 2 2 0
4 DESC `schoolyears` 2 2 0
5 DESC `sexes` 2 2 0
6 DESC `summerdivisions` 2 2 0
7 DESC `pmprograms` 2 2 0
8 SELECT `Applicant`.`id`, `Applicant`.`schoolyear_id`,
`Applicant`.`lastname`, `Applicant`.`firstname`,
`Applicant`.`date_entry`, `Applicant`.`date_update`,
`Applicant`.`note`, `Applicant`.`status_id`, `Applicant`.`school`,
`Applicant`.`grade_apply`, `Applicant`.`division_id`,
`Applicant`.`application_date`, `Applicant`.`dob`, `Applicant`.`phone`,
`Applicant`.`phone_m_work`, `Applicant`.`phone_f_work`,
`Applicant`.`street`, `Applicant`.`city`, `Applicant`.`state`,
`Applicant`.`country`, `Applicant`.`zip`, `Applicant`.`nc_parent`,
`Applicant`.`nc_street`, `Applicant`.`nc_city`, `Applicant`.`nc_state`,
`Applicant`.`nc_country`, `Applicant`.`nc_zip`, `Applicant`.`nickname`,
`Applicant`.`sex_id`, `Applicant`.`parent`,
`Applicant`.`summerdivision_id`, `Applicant`.`pmprogram_id`,
`Division`.`id`, `Division`.`name`, `Status`.`id`, `Status`.`name`,
`SchoolYear`.`id`, `SchoolYear`.`name`, `Sex`.`id`, `Sex`.`name`,
`SummerDivision`.`id`, `SummerDivision`.`name`, `PMProgram`.`id`,
`PMProgram`.`name` FROM `applicants` AS `Applicant` LEFT JOIN
`divisions` AS `Division` ON `Applicant`.`division_id` =
`Division`.`id` LEFT JOIN `statuses` AS `Status` ON
`Applicant`.`status_id` = `Status`.`id` LEFT JOIN `schoolyears` AS
`SchoolYear` ON `Applicant`.`schoolyear_id` = `SchoolYear`.`id` LEFT
JOIN `sexes` AS `Sex` ON `Applicant`.`sex_id` = `Sex`.`id` LEFT JOIN
`summerdivisions` AS `SummerDivision` ON
`Applicant`.`summerdivision_id` = `SummerDivision`.`id` LEFT JOIN
`pmprograms` AS `PMProgram` ON `Applicant`.`pmprogram_id` =
`PMProgram`.`id` WHERE `Applicant`.`id` = '3580' LIMIT 1 1
1 1
9 INSERT INTO `applicants`
(`id`,`schoolyear_id`,`lastname`,`firstname`,`date_entry`,`date_update`,`note`,`status_id`,`school`,`grade_apply`,`division_id`,`application_date`,`dob`,`phone`,`phone_m_work`,`phone_f_work`,`street`,`city`,`state`,`country`,`zip`,`nc_parent`,`nc_street`,`nc_city`,`nc_state`,`nc_country`,`nc_zip`,`nickname`,`sex_id`,`parent`,`summerdivision_id`,`pmprogram_id`)
VALUES
(NULL,'15','Zoposc','Oscar',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,NULL)
1 0
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
