I do have a Model called Community
I do have a attribute called author in communities table.
I do have models/community.rb
However this won't work. Why?
@communities = Community.find_by_author(params[:author])
Asked
Active
Viewed 49 times
-1
Sergio Tulentsev
- 226,338
- 43
- 373
- 367
MKK
- 2,713
- 5
- 31
- 51
-
1Model file should be `community.rb`, not `communities.rb` – Sergio Tulentsev Feb 01 '13 at 18:30
-
@SergioTulentsev Sorry about that it's my typo in question. – MKK Feb 01 '13 at 18:32
-
find_by_author will return only one record not multiple records. Anyway what u getting in @communities – Rahul Tapali Feb 01 '13 at 18:37
-
Thats how the implementation.. It returns first matching record. – Rahul Tapali Feb 01 '13 at 18:40
-
@MKK Because that's how it works. – Dave Newton Feb 01 '13 at 18:41
-
If you want all records user Community.where(:author : params[:author]) – Rahul Tapali Feb 01 '13 at 18:42
-
@checkit aha, that's why. Can you show me how to fetch all the records that matches with the same author?? – MKK Feb 01 '13 at 18:42
-
@checkit thanks:) Could you please post that as answer so that I can vote up? – MKK Feb 01 '13 at 18:44
1 Answers
1
find_by will give only first matching record. So use where to get all matching records.
Community.where(:author => params[:author])
Rahul Tapali
- 9,887
- 7
- 31
- 44
-
2Or `Community.find_all_by_author(params[:author])` (at least it used to work in rails 2.x) – Sergio Tulentsev Feb 01 '13 at 18:50
-
Is there an incorrect hash syntax? It should be `author: params[:author]` or `:author => params[:author]`, shouldn't it? – Sergey Kishenin Feb 01 '13 at 18:58
-
@SergioTulentsev You can't use `where` in Rails 2. Thats why we use finder methods. But its better to use `where` when you have. Nice explanation : http://stackoverflow.com/questions/11232971/rails-find-all-by-vs-where – Rahul Tapali Feb 01 '13 at 19:05
-
@checkit: I am pro-where too. Just, you know, listing all options. – Sergio Tulentsev Feb 01 '13 at 19:08