原创作者: hideto
阅读:1783次
评论:0条
更新时间:2011-05-26
数据库查询的conditions除了简单的字符串,还可以用数组,range,nil等等,看看代码:
find_by都可以使用数组、range、nil,确实不错。
Task.find(:all, :conditions => ["complete=? and priority=?", false, 3]) Task.find(:all, :conditions => ["complete=? and priority IS ?", false, nil]) Task.find(:all, :conditions => ["complete=? and priority IN (?)", false, [1,3]]) Task.find(:all, :conditions => ["complete=? and priority IN (?)", false, 1..3]) Task.find(:all, :conditions => { :complete => false, :priority => 1 }) Task.find(:all, :conditions => { :complete => false, :priority => nil }) Task.find(:all, :conditions => { :complete => false, :priority => [1,3] }) Task.find(:all, :conditions => { :complete => false, :priority => 1..3 }) Task.find_all_by_priority(1..3)
find_by都可以使用数组、range、nil,确实不错。
评论 共 0 条 请登录后发表评论