Of course your solution is better and this is what I do too. I just wanted to show Lauren how to do with her own setup.
On 18 août, 14:43, "Jon Bennett" <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
