First, try setting DEBUG to 2, so you can see the actual SQL being
generated.
Second, try specifying the conditions like this:
$data = $this->paginate(array('price1' => "<= 100", 'price2' =>
">=400"));
On Jan 25, 4:05 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> I'm using the latest nightly 1.2 (2007.01.24) and am trying to use some
> custom conditions in my pagination call. Basically I want some SQL
> that looks like:
>
> SELECT * FROM table WHERE price1<='100' AND price2>='400'
>
> I tried using "price1<='100' AND price2>='400'" as the $scope argument
> to the paginate() call, but I don't get any results back (there should
> actually be many many results for that query).
>
> Is there a better way to get paginate() to use my conditions? I don't
> think I can specify conditions as an array, since I'm using <= and >=,
> not just =.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
