How to have condition in ActiveRecord update

Question

I am trying to update a record. Am using the following code.

Proddiscount.update({:prodid => params[:id]}, {:discount=>params[:discount]})

Query Im trying to have is:

update proddiscount set discount = '' where prodid = ''

Answer 1

How about doing this:

@prod = Proddiscount.find(:first, :conditions => {prodid => params[:id]})
@prod.update_attributes({:discount=>params[:discount]})

Answer 2

If prodif is not a primary key, use update_all (read more here)

Proddiscount.update_all("discount = #{params[:discount]}", ["prodid = ?", params[:prodid])

But it won't trigger validations.