Ok, if you cannot modify the database tables, then the other option is to use sub-queries, see the CakePHP book at:
http://book.cakephp.org/2.0/en/models/retrieving-your-data.html#sub-queries
My understanding of this, is that you first construct the SQL statement for finding all the parent ids in the child table, then uses that SQL statement as a condition for finding all parent records with the id not being found by the previous SQL statement.
Hope that helps you out :)
Enjoy, John
On Monday, 17 November 2014 06:05:48 UTC+2, Kento Furui wrote:
-- http://book.cakephp.org/2.0/en/models/retrieving-your-data.html#sub-queries
My understanding of this, is that you first construct the SQL statement for finding all the parent ids in the child table, then uses that SQL statement as a condition for finding all parent records with the id not being found by the previous SQL statement.
Hope that helps you out :)
Enjoy, John
On Monday, 17 November 2014 06:05:48 UTC+2, Kento Furui wrote:
Thank you John.counterCache seems to be a good idea.But there must be a way to do this without adding a column to an existing table.[snip]
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment