Hi, Using the Model::find() method seems to be preferred over using Model::query(). However, I can't seem to wrap my head around turning the following SQL query into params for the find() method:
Pseudo code: select all the purchases that have not yet been paid for. SELECT p.* FROM accounts a, purchases p WHERE a.id = p.account_id AND p.id NOT IN (SELECT purchase_id FROM payments WHERE account_id = 1) AND a.id = 1; --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
