# ActiveRecord :conditions syntax errors

**URL:** <https://www.ruby-forum.com/t/activerecord-conditions-syntax-errors/131835>\
**Category:** Rails\
**Created:** [March 13, 2008, 6:16pm UTC](https://www.ruby-forum.com/t/activerecord-conditions-syntax-errors/131835 "2008-03-13T18:16:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jeremy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/82dd89/32.png) [@jeremy](https://www.ruby-forum.com/u/jeremy)\
**Post date:** [March 13, 2008, 6:16pm UTC](https://www.ruby-forum.com/t/activerecord-conditions-syntax-errors/131835/1 "2008-03-13T18:16:17Z")

</div>

Having trouble when I try to add a second condition to find. I’ve  
tried search and referencing  
[ActiveRecord::Base](http://api.rubyonrails.org/classes/ActiveRecord/Base.html),  
but not seeing a clear answer on my syntax.

Working code:  
def cc\_class\_six  
@products = Product.find(:all, :conditions =\>[‘store LIKE ?’, ‘%’ +  
‘class’ +‘%’])  
return @products  
end

Code where I’ve added a second condition to find by that returns  
syntax errors:  
def cc\_class\_six  
@products = Product.find(:all, :conditions =\>[‘store LIKE ?’, ‘%’ +  
‘class’ +‘%’] and ["city=‘corpus christi’ "])  
return @products  
end

I’ve tried several variations, but all return syntax errors:  
:conditions =\>[‘store LIKE ?’, ‘%’ + ‘class’ +‘%’ and "city=‘corpus  
christi’ "])  
:conditions =\>[‘store LIKE ?’, ‘%’ + ‘class’ +‘%’ and ‘city=‘corpus  
christi’ ‘])  
:conditions =\>[‘store LIKE ?’, ‘%’ + ‘class’ +’%’] and ['city=‘corpus  
christi’ '])

Any ideas?

---

<div class="post-metadata">

**Author:** ![jeremy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/82dd89/32.png) [@jeremy](https://www.ruby-forum.com/u/jeremy)\
**Post date:** [March 13, 2008, 6:22pm UTC](https://www.ruby-forum.com/t/activerecord-conditions-syntax-errors/131835/2 "2008-03-13T18:22:35Z")

</div>

:conditions =\>[“store LIKE ? AND city= ?”, ‘%’ + ‘class’ +’%’, ‘corpus  
christi’]

---

<div class="post-metadata">

**Author:** ![jeremy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/82dd89/32.png) [@jeremy](https://www.ruby-forum.com/u/jeremy)\
**Post date:** [March 13, 2008, 6:42pm UTC](https://www.ruby-forum.com/t/activerecord-conditions-syntax-errors/131835/3 "2008-03-13T18:42:24Z")

</div>

Thanks! I knew it would be something simple I was overlooking.

On Mar 13, 12:22 pm, Thorsten M. \<rails-mailing-l…@andreas-