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