hey
when you use the -! operator you see the deprecated message that
unescaping isn't supported - use query or overload dbo_your_db_engine
(look how it was implemented before)
--
Marcin Domanski
http://kabturek.info
On Sat, Jul 12, 2008 at 9:12 AM, aranworld <[EMAIL PROTECTED]> wrote:
>
> This is the condition I want to display:
>
> AND `Grant`.`date` BETWEEN
> DATE_SUB('2006-01-01',INTERVAL `Grant`.`term` MONTH) AND
> '2005-12-31'
>
> This comes really close:
>
> $cond['and'] = array(
> "Grant.date BETWEEN ? AND ?" => array(
> "DATE_SUB('2007-01-01',INTERVAL `Grant`.`term` MONTH)',
> '2006-12-31')
> );
>
> However the query that Cake generates automatically puts quotes around
> each argument in the BETWEEN clause, so the query that Cake produces
> is:
>
> AND `Grant`.`date` BETWEEN
> 'DATE_SUB('2006-01-01',INTERVAL `Grant`.`term` MONTH)' AND
> '2005-12-31'
>
> This latter one does not work, because the DATE_SUB function has
> single quotes around it, which prevents the date math from being done.
>
> Is there any way to set up a query like this this without hand-coding
> the query?
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
