On Wed, Jan 2, 2013 at 1:00 AM, Hillary Hueter <[email protected]> wrote:

> My form fails with the error Mysql2::Error: Column 'date_of_birth' cannot
> be null. However the Request Parameters have a value for date_of_birth,
> so i'm not sure whats going on.
> Request:
>
>
> {"utf8"=>"✓",
>  "authenticity_token"=>"3njnNBX4VgoV32kau3OALfhdIP00Bq78we6EKD7OXHo=",
>  "pilgrim"=>{"surname"=>"Lorem",
>  "first"=>"Ipsum",
>  "middle"=>"Lorem",
>  "aka"=>"Lorem",
>  "title"=>"Mrs. ",
>  "address"=>"111 Mockingbird Lane",
>  "city"=>"City",
>  "state"=>"CA",
>  "email"=>"[email protected]",
>  "telephone"=>"889-279-2727",
>  "nationality"=>"USA",
>  "passport_number"=>"123455",
>  "expiration"=>"06-15-2015",
>  "date_of_birth"=>"06-15-1086",
>  "jordan"=>"yes",
>  "room"=>"Share",
>  "leader"=>"Group Leader",
>  "price"=>"4000",
>  "deposit"=>"500",
>  "trip_id"=>"44",
>  "balance"=>"3500"},
>
> "commit"=>"Save"}
>
>
> Here's a gist with the form and controller code that's causing the issue.
> https://gist.github.com/4429457
>
> --
> 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 [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msg/rubyonrails-talk/-/oKhWrEOR_WcJ.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
What is the datatype that you have set for the date_of_birth column? If
it's date-time, then you can try convert the string into Date object first
and then store the parsed value in database.

-- 
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 [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to