Most of the time I want the orphan records to be deleted, as they would have been done by CakePHP (using dependent=>true) if I did not have the MySQL relations in place.
It was very rare that I created orphans in my code before using MySQL relations, as I use counterCache a lot and where I did not want to delete a record if it had dependents I would check against the counterCache value. It seems I have potentially took one step forward and two steps back. I value the fact that the database WILL NOT allow me to create orphans as a safety net, but if I have to create extra code to allow me to delete a record and it's dependents, something that was done automatically beforehand, then I think I will be removing the MySQL relations :( -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
