Walter Lee Davis on 24 Jan 2008 08:47:10 -0800

[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

Re: [PhillyOnRails] ActiveRecord: updating a single attribute

Is there a reason for you that this is important? Is there any difference functionally between

update documents set field1 = [current value], ... fieldN = [current value], normal_views = X where id = 123


update documents set normal_views - X where id = 123


Other than brevity of SQL logs, anyway?


On Jan 24, 2008, at 12:33 PM, Chris Cera wrote:

Hi everyone,

Is there a way to update just one attribute of a record without
causing all the attributes to be re-set?  When I use the
update_attribute() or increment(), since they call save() it
causes every attribute to get re-set.  I verified this in the
mysql 'General Query Log'.  Example:
    item.update_attribute(:normal_views, item.normal_views + 1)

I feel that there must be a more elegant solution than this:
sql = 'UPDATE documents SET normal_views = normal_views + 1 WHERE id = ' +

Any suggestions are greatly appreciated.  Thank you, -Chris


Christopher D. Cera
CTO, Hovitate LLC
P: 215.435.2289
F: 267.295.7369
To unsubscribe or change your settings, visit:

To unsubscribe or change your settings, visit: