| @@ -300,7 +300,7 class Query < ActiveRecord::Base | |||||
| 300 | when "=" |
|
300 | when "=" | |
| 301 | sql = sql + "#{db_table}.#{db_field} IN (" + v.collect{|val| "'#{connection.quote_string(val)}'"}.join(",") + ")" |
|
301 | sql = sql + "#{db_table}.#{db_field} IN (" + v.collect{|val| "'#{connection.quote_string(val)}'"}.join(",") + ")" | |
| 302 | when "!" |
|
302 | when "!" | |
| 303 | sql = sql + "#{db_table}.#{db_field} NOT IN (" + v.collect{|val| "'#{connection.quote_string(val)}'"}.join(",") + ")" |
|
303 | sql = sql + "(#{db_table}.#{db_field} IS NULL OR #{db_table}.#{db_field} NOT IN (" + v.collect{|val| "'#{connection.quote_string(val)}'"}.join(",") + "))" | |
| 304 | when "!*" |
|
304 | when "!*" | |
| 305 | sql = sql + "#{db_table}.#{db_field} IS NULL" |
|
305 | sql = sql + "#{db_table}.#{db_field} IS NULL" | |
| 306 | when "*" |
|
306 | when "*" | |
General Comments 0
You need to be logged in to leave comments.
Login now