You have to use string based conditions for that - not the array key
=> value.
$where['AND'][] = 'DATE(Table.datefield) <= CURDATE()';
On Jun 10, 3:54 pm, Mr-Yellow <[EMAIL PROTECTED]> wrote:
> Still puts quotes around CURDATE.
>
> $where['AND']['DATE(Table.datefield)'] = '<= -!CURDATE()';
> $where['AND']['DATE(Table.datefield) <='] = '-!CURDATE()';
> $where['AND']['DATE(Table.datefield) <= -!'] = 'CURDATE()';
>
> All result in variations of wrongly interpreted SQL conditions.
>
> -Ben
>
> On Jun 10, 3:39 pm, "Dr. Tarique Sani" <[EMAIL PROTECTED]> wrote:
>
> > On Tue, Jun 10, 2008 at 10:51 AM, Mr-Yellow <[EMAIL PROTECTED]> wrote:
>
> > > This:
> > > $where['AND']['Table.textfield'] = 'LIKE %word%';
> > > Has been changed to:
> > > $where['AND']['Table.textfield LIKE'] = '%word%';
>
> > > This:
> > > $where['AND']['DATE(Table.datefield)'] = '<= -!CURDATE()';
> > > Has been changed to:
> > > ??????
>
> > Quoting from the release announcement
>
> > "To help ensure that applications are secure with no extra effort on the
> > part of the developer, we have moved all operators used in conditions to the
> > "key" side. For example, $conditions = array('Model.field >' => $value); is
> > the new syntax. We have maintained backwards compatibility for the most
> > common cases, you will need to update your affected application code."
>
> > hth
>
> > Tarique*
> > *
> > --
> > =============================================================
> > Cheesecake-Photoblog:http://cheesecake-photoblog.org
> > PHP for E-Biz:http://sanisoft.com
> > =============================================================
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" 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
-~----------~----~----~----~------~----~------~--~---
