Does anyone have any idea how to put together an array to make the DATE_FORMAT work?
On Apr 8, 7:21 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > I'm trying to use a findall query and use the MYSQLDATE_FORMAT > function. > > The code is > > $criteria = array(); > $criteria['DATE_FORMAT(Schedule.start,\'%w\')'] = 3; > $this->Schedule->findAll($criteria); > > My code as it runs produces... > > SELECT * FROM `studioschedules` AS > `Schedule`WHEREDATE_FORMAT(`Schedule`.`start,'%w'`) = 3 > > which causes an error. What is the correct way to put this query > together? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
