Duane Morin wrote:
All I want to do is change one field of my object and update it in the database. I thought that this was the syntax:
obj.update_attribute(:status_id, 5)
but the SQL statement that's generated it still attempting to specify values for every single field in the object. This causes me problems (one of the fields is a very long XML object) so I'm trying to avoid it. What's the Ruby syntax that will generate just the single statement to update object_table set status_id=5 where id=xxx?
Duane,
I think Model.update_all will do what you want. You can get the exact syntax from Rails doc.
Long www.edgesoft.ca