Show us what you have tried so far ... it will be easier to make sense of your SQL or Cake conditions
On Sep 12, 9:01 am, CaStarCo <[email protected]> wrote: > Hello, I have a doubt about the best way to do a complex search. > > I have a model "Agreements", every agreement entity have a 'state' field, > wich can have the 'expired' value, I want to show all the agreements that > haven't expired, but not the expired ones... with an exception. The > Agreement model refers to another model : AgreementModels , I want that if > there isn't another agreement not expired with a specific model, then the > expired agreement must be shown anyway. > > My problem is the last condition, I think I must do at least two searches, > but if there is a way... I'll give a lot of thanks :) . > > Thanks in advance! -- 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
