Question

我已经尝试了我能够想象的各种看法, have头取得了100%的成功。这样做的首选(或以任何方式工作)方式:

在使用地处时,我无法对浮差错进行消沉。

Question.where( id not in (?) AND rating.id = ? AND pvalue BETWEEN ? , not_in, rating_id, 0.0..100.0).limit(25)

在使用条件仓时,我可以说明如何将结果限制在阵列。因此,我尝试了两个条件,但我并不认为(吗)部分的阴.不会变成不成阵的血清回归结果。

Question.find_all_by_rating_id(rating_id, :limit=>25, :conditions => [ id not in (?) , not_in], :conditions=>{:pvalue => 0.0..100.0})

以上是第一种条件(在任何途径有两条 look)和返回。

SELECT "questions".* FROM "questions" WHERE "questions"."rating_id" = 458 AND ("questions"."pvalue" BETWEEN 0.0 AND 100.0) LIMIT 25

So I need a combination of the hash condition and the id not in condition. Any help is appreciated!

注:价值为浮动,而不是一阵ids,我不想回来。

Answer 1

Try

Question.where("id not in (?) AND rating.id = ? AND pvalue BETWEEN ? AND ?", 
  not_in, 
  rating_id, 
  0.0, 100.0
).limit(25)