Rails sql 语句 转成 activerecord 查询

yeyong14 · May 02, 2014 · Last by u1378130755 replied at May 07, 2014 · 2665 hits

在首页上要展示其中的几个大类,不是连续的, 刚开始是这样的

   Categroy.find(1,4,5)
#如果只有一个id的话,就会报错
ActiveRecord::RecordNotFound: Couldn't find all Categories with IDs (1, 3, 5) (found 2 results, but was looking for 3)

后来改成这样了就行了,但这样感觉有点 php 的味道

Category.find_by_sql('select id, name from categories where id in(1,4,5)').each do |category|
  #TODO
end
Category.where(:id => [1,4,5])

如何呢?

@chitsaou 谢谢,可以的

3 Floor has deleted
You need to Sign in before reply, if you don't have an account, please Sign up first.