Rails: Find all with conditions

Question

in my app I have users from different countries and want to perform finds on them

I tried to do it like this in the index action

 @fromcanada = User.find(:all, :country => 'canada') 

but I got the error

 Unknown key: country 

However, so that leads me to ask, what can become a key? In my database schema file, I have a "country" column on the users table.

t.string   "country" 

Furthermore, when I did a find all

@users = User.all 

I was able to do this

<%= user.country %></p> 

Can you explain why my find all with conditions didn't work? and show me how I should have done it?

Answer 1

Try this.

@fromcanada = User.find(:all, :conditions => { :country => 'canada' }) 

edit: As jason328 pointed out, the above answer is deprecated in 3.2, and an updated answer would be

@fromcanada = User.where(:country => 'canada')