Sorry, I didn't understand what you wanted me to do with those links. I see that I can post public code at CakeBin, but what are the Google results?
I am using 1.1.15.5144 under PHP 4. The problem may have started after I upgraded from 1.1.14.4797, but I don't see anything listed under bugs at trac.cakephp.org... Should I roll back to 1.1.14 and see if the problems go away? (groan...) Thanks! On May 27, 6:50 am, AD7six <[EMAIL PROTECTED]> wrote: > On May 27, 4:21 am, squidliberty <[EMAIL PROTECTED]> wrote: > > > The $conditions I specify above create the following sql bit: > > WHERE NOT (`Listing`.`expiration` BETWEEN '1' AND '1180232564') AND > > (`Listing`.`title` LIKE '%cat%') OR (`Listing`.`description` LIKE '%cat > > %') AND (`Listing`.`title` LIKE '%dog%') OR (`Listing`.`description` > > LIKE '%dog%') > > > I believe that what I need would be this: > > WHERE NOT (`Listing`.`expiration` BETWEEN '1' AND '1180232564') AND > > ((`Listing`.`title` LIKE '%cat%') OR (`Listing`.`description` LIKE > > '%cat%')) AND ((`Listing`.`title` LIKE '%dog%') OR > > (`Listing`.`description` LIKE '%dog%')) > > > Note the extra parenthesis, creating the logic "X and (A or B) and (M > > or N)". How do I create groups like this? > > It should do that anyway, since thats pretty much the point of an OR. > What revision are you using and If you use the latest code, does that > still happen? > > I guess you didnĀ“t like this bit: > > > >http://www.google.com/search?q=online+sql+format+http://bin.cakephp.org= > > >readable output. > > Cheers, > > AD --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---