How can I Insert the value null to a database column with ruby code

Question

How can I Insert the value null to a database column with ruby code? I'm using a rails application.

shingara · Accepted Answer · 2010-11-03 09:50:01Z

6

user.title = nil
user.save

answered Nov 3, 2010 at 9:50

shingara

47k12 gold badges102 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

I tried to save the value nil to the database but the database saves the value 'on'.. Is this some ruby related problem?

depend how you column is define.

Ariejan · Accepted Answer · 2010-11-03 10:11:00Z

0

As shingara said or:

user.update_attribute(:title, nil)

answered Nov 3, 2010 at 10:11

Ariejan

11.1k6 gold badges45 silver badges40 bronze badges