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
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
