I actually wrote it wrong in the first post (d'oh!): price1 and price2
are actually the same field in the table called price.
Here's what finally worked:
$conditions = array();
$conditions[] = array('price' => '>=100');
$conditions[] = array('price' => '<= 400');
$this->paginate($conditions);
On Jan 25, 4:44 pm, "nate" <[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
