------Original Message------ From: Adinda Praditya To: [email protected]; Subject: [id-ruby] Gimana generate query negatif?
Product.find_by_vendor_id(nil)
SELECT * FROM products WHERE (*products.`vendor_id` IS NULL*) LIMIT 1
--
Product.find(:first, :conditions => {:vendor_id => nil})
---
Tapi, kalo
Product.find_by_vendor_id(!nil)
SELECT * FROM products WHERE (*products.`vendor_id` = 1*) LIMIT 1
--
Product.find(:first, :conditions => ["vendor_id <> ?", nil])
---
