Hi Kalt, > @jon : the "unpaid" status should not be in the Payments but in the > Purchases
ahh, yes - she wants all Purchases that have no payments made - I was really just trying to illustrate how containable can be used instead of the old hasOne/belongsTo hack. a far easier solution to the problem would be to store an interger for the status, you could assign things like so: 0 - unpaid/unprocessed 1 - paid/processed 2 - dispatched 3 - refunded no need to tunnel through any related tables, or make any calculations. I would have thought going about things would greatly reduce the number of queries/post processing required when outputting a list of orders as well. hth jon -- jon bennett w: http://www.jben.net/ iChat (AIM): jbendotnet Skype: jon-bennett --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
