Re: Weird query pagination

[Dee Johnson]

Turns out it was the query acting wonky...here is a query that embodies everything i wanted but actually worked.

$myquery = $this->paginate('Model',  array('OR' =>
            array('Model.field1 LIKE' => '%,' . $var . ',%',
            array('Model.field1 LIKE' => '%,' . $var),
            array('Model.field1 LIKE' => $var . ',%')                
        ),
            'AND' => array(
                'NOT' => array(
                    'Model.field2' => array('6', '10'), array('Model.field3' => '2')                
                )
            )
        ));

-- 
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org 
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
 
 
To unsubscribe from this group, send email to
cake-php+unsubscribe@xxxxxxxxxxxxxxxx For more options, visit this group at http://groups.google.com/group/cake-php