rubyonrailsin

cool thanks

On Mar 23, 5:21 pm, Colin Law <clan...@googlemail.com> wrote:
> On 23 March 2010 16:11, ES <emsto...@gmail.com> wrote:
>
> > Actually, I had :null=> true
>
> > On Mar 23, 5:01 pm, ES <emsto...@gmail.com> wrote:
> >> how do I change the column in a table to allow null?
>
> >> I have
>
> >>     change_column :docs, :orga,    :null
>
> If you check the docs for change_column you will see that you need the
> column type even if it has not changed
> change_column :docs, :orga,  whatever_type_it_is  :null=>true
>
> Colin
>
>
>
> >> in my migration file but I get an error:
>
> >> Mysql::Error: You have an error in your SQL syntax; check the manual
> >> that corresponds to your MySQL server version for the right syntax to
> >> use near 'null DEFAULT '' NOT NULL' at line 1: ALTER TABLE `docs`
> >> CHANGE `orga` `orga null DEFAULT '' NOT NULL
>
> > --
> > You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
> > To post to this group, send email to rubyonrails-talk@googlegroups.com.
> > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
> > For more options, visit this group athttp://groups.google.com/group/rubyonrails-talk?hl=en.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.