Re: Complex LIKE Conditions in CakePHP

2010-12-23 Thread Dr. Loboto
array( array('Product.short_description LIKE' = %_ $plural _%), array('Product.short_description LIKE' = %_ $singular _%) ) On 22 дек, 18:35, Christopher Geheran cgehe...@gmail.com wrote: So, I am attempting to have multiple like conditions on the same field, as follows, and Im sending this

Re: Complex LIKE Conditions in CakePHP

2010-12-23 Thread nurvzy
I'm assuming you want an OR -- Dr. Loboto's produce an AND condition. LIKE plural AND LIKE singular doesn't make a whole lot of sense. You probably want LIKE plural OR LIKE singular to be found in the description. $conditions = array( 'OR' = array( array('Product.short_description LIKE' =

Complex LIKE Conditions in CakePHP

2010-12-22 Thread Christopher Geheran
So, I am attempting to have multiple like conditions on the same field, as follows, and Im sending this into the pagination class. array( 'Product.short_description LIKE' = array(%_ $plural _%, %_ $singular _%) ) Since the above is an array, cakephp is attempting to add the IN clause into

Re: Complex LIKE Conditions in CakePHP

2010-12-22 Thread Sergei
On Dec 22, 11:35 pm, Christopher Geheran cgehe...@gmail.com wrote: array(    '0'='Product.short_description LIKE' = %_ $plural _%,    '1'='Product.short_description LIKE' = %_ $singular _% ) Cake didn't seem to like that either. Any suggestions? Make condition a string: