On Feb 21, 8:54 am, "ianh" <[EMAIL PROTECTED]> wrote:
> 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
Try
$conditions = aa('dayofweek(`Course`.`start`)', $var);
Note the backticks.
HTH,
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
-~----------~----~----~----~------~----~------~--~---
