$paginatorScope['Advert.status BETWEEN ? AND ?'] = array($value1, $value2);
On Jun 28, 8:13 am, Mike52 <[EMAIL PROTECTED]> wrote: > I am having trouble specifying a paginator condition with the BETWEEN > operator after upgrading to RC2. > > In 1.2.0.6311 beta: > $paginatorScope["Advert.status BETWEEN"] = "A AND B"; > > generates corresponding SQL: > `Advert`.`status` BETWEEN 'A' AND 'B' > > In 1.2.0.7296 RC2 the same condition generates: > `Advert`.`status` = 'BETWEEN A AND B' > > If I change the condition to: > $paginatorScope["Advert.status BETWEEN"] = "A AND B"; > > this generates: > `Advert`.`status` BETWEEN 'A AND B' > > Looks slightly better, but still not valid SQL. What is the correct > way to specify the BETWEEN syntax in RC2 ? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---