Re: Desparately trying to search a single DB field for multiple individual terms with find()

2008-11-05 Thread Nick
OH MAN! I see exactly what I was missing, I wasn't defining each condition within the OR array as an array! Thank you for pointing it out. I must have typed and re-typed those lines so many times that I just overlooked it... That settled it, thanks a ton for the help! On Nov 5, 4:27 pm, tekno

Re: Desparately trying to search a single DB field for multiple individual terms with find()

2008-11-05 Thread teknoid
How can you tell me you looked at the manual, when the example is right there in complex find conditions? http://book.cakephp.org/view/74/Complex-Find-Conditions (I know 'cause I remember adding it :)) $this->Post->find('all', array('conditions'=>array( 'OR'=>array(array('Post.ti

Re: Desparately trying to search a single DB field for multiple individual terms with find()

2008-11-05 Thread Nick
I've been staring at the manual all day... maybe I am missing something and if so, my bad. If I build an or statement without the foreach loop, I would do it as follows: $conditions = array( 'conditions'=> array( 'OR' => array(

Re: Desparately trying to search a single DB field for multiple individual terms with find()

2008-11-05 Thread teknoid
Nothing to do with cake. Your usage is incorrect. Please review how to correctly build an 'OR' condition in the manual, there are multiple examples. On Nov 5, 2:45 pm, Nick <[EMAIL PROTECTED]> wrote: > Yes, thats my biggest issue, I don't know if there is a way within > Cake to define multiple ar

Re: Desparately trying to search a single DB field for multiple individual terms with find()

2008-11-05 Thread Nick
Yes, thats my biggest issue, I don't know if there is a way within Cake to define multiple array values for 'Question.content LIKE' I've tried building it like this, however the SQL query built off of this array isn't correct: $term = $this->data['Question']['searchTerm'];

Re: Desparately trying to search a single DB field for multiple individual terms with find()

2008-11-05 Thread teknoid
Seems like you are overriding your condition each time... On Nov 5, 1:49 pm, Nick <[EMAIL PROTECTED]> wrote: > I'm hoping someone can help.  I'm fairly new to CakePHP but am > thoroughly enjoying coding with it. > > Basically I've got a field within a table that contains my content. > I'm trying