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 [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
-~----------~----~----~----~------~----~------~--~---
