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