« What you can expect as $results in afterFind()
Populating a SELECT box with distinct values »

SQL functions or keywords in CakePHP conditions

For those who missed the information, starting from CakePHP 1.2 it is no longer possible to use the magic tag -! in your condition to prevent your SQL function or keyword to be enclosed in quotes.

The recommended way now is to place it into the key or not make the array associative at all. It is no longer possible to put it into the value part of the definition.

So instead of:

  1. array(
  2.   ‘DATE_ADD(Payment.modified, INTERVAL 2 DAY) >’ =>  
  3.   ‘CURRENT_DATE’)

you have to use:

  1. array(
  2.   ‘DATE_ADD(Payment.modified, INTERVAL 2 DAY) > CURRENT_DATE’)

This entry was posted on Tuesday, December 9th, 2008 at 3:21 pm and is filed under CakePHP. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “SQL functions or keywords in CakePHP conditions”

  1. Rubens Mariuzzo Says:
    May 29th, 2009 at 7:25 am

    Thanks a lot it save me some extra hours. Thanks.

Leave a Reply