Hi all, I'm working on an app to allow people to book courses online. I want users to be able to select courses by the day on which they are held. I have a "start" date (in datetime format) and have been trying to create a conditions array a bit like this:
$conditions = aa('dayofweek(Course.start)', $var); The statement generated by Cake has this at the end: AND (`dayofweek(Course`.`start)` = '2') but unsurprisingly the DB returns 1054: Unknown column 'dayofweek(Course.start)' in 'where clause' Does anybody know if the above possible using find/findAll or am I going to need to resort to a query? Thanks, Ian --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---