# Find conditions syntax problem

**URL:** <https://www.ruby-forum.com/t/find-conditions-syntax-problem/147487>\
**Category:** Rails\
**Created:** [September 2, 2008, 1:01pm UTC](https://www.ruby-forum.com/t/find-conditions-syntax-problem/147487 "2008-09-02T13:01:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tyliong](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/e9a140/32.png) [@tyliong](https://www.ruby-forum.com/u/tyliong)\
**Post date:** [September 2, 2008, 1:01pm UTC](https://www.ruby-forum.com/t/find-conditions-syntax-problem/147487/1 "2008-09-02T13:01:06Z")

</div>

Hi,

could u guys please help me with this syntax:

SglineItem.find(:first, :conditions =\> {[‘sguser\_id =?’, params[:ad]],  
[‘groceries\_id =?’, params[:bd]]})

## Full Code:

def add\_to\_cart

if SglineItem.find(:first, :conditions =\> {[‘sguser\_id =?’,  
params[:ad]],[‘groceries\_id =?’, params[:bd]]})== nil

def add\_to\_cart  
if SglineItem.find(:first, :conditions =\> {[‘sguser\_id =?’,  
params[:ad]],[‘groceries\_id =?’, params[:bd]]})== nil

```
item = SglineItem.new
item.sguser_id= params[:ad]
item.groceries_id=params[:bd]
item.save!

  else

item = SglineItem.find(:first, :conditions => {['sguser_id =?',

```

params[:ad]],[‘groceries\_id =?’, params[:bd]]})  
item.quantity +=1  
end  
redirect\_to :action =\> “panel”, :id =\> params[:ad]  
end

* * *

it gives undefined method `to\_sym’ for [“sguser\_id =?”, “3”]:Array

---

<div class="post-metadata">

**Author:** ![tyliong](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/e9a140/32.png) [@tyliong](https://www.ruby-forum.com/u/tyliong)\
**Post date:** [September 2, 2008, 1:05pm UTC](https://www.ruby-forum.com/t/find-conditions-syntax-problem/147487/2 "2008-09-02T13:05:47Z")

</div>

On 2 Sep 2008, at 12:00, tyliong wrote:

> Hi,
> 
> could u guys please help me with this syntax:
> 
> SglineItem.find(:first, :conditions =\> {[‘sguser\_id =?’, params[:ad]],  
> [‘groceries\_id =?’, params[:bd]]})

That’s just wrong. Either conditions is an array eg

:conditions =\> [‘foo=? and bar= ?’, foo, bar]

or it’s a hash of column names and values

:conditions =\> {:foo =\> foo, :bar =\>bar}

But not some mish-mash of the two.

Fred

---

<div class="post-metadata">

**Author:** ![tyliong](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/e9a140/32.png) [@tyliong](https://www.ruby-forum.com/u/tyliong)\
**Post date:** [September 2, 2008, 1:07pm UTC](https://www.ruby-forum.com/t/find-conditions-syntax-problem/147487/3 "2008-09-02T13:07:32Z")

</div>

Thanks that worked

---

<div class="post-metadata">

**Author:** ![tyliong](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/e9a140/32.png) [@tyliong](https://www.ruby-forum.com/u/tyliong)\
**Post date:** [September 2, 2008, 2:03pm UTC](https://www.ruby-forum.com/t/find-conditions-syntax-problem/147487/4 "2008-09-02T14:03:51Z")

</div>

Hi, I would recommend referencing the Rails API when you have questions  
about the syntax and/or methods. Thus, it can be found at the following  
location:  
[http://api.rubyonrails.com](http://api.rubyonrails.com)

Good luck,

-Conrad