On Thu, Jan 3, 2013 at 1:07 AM, tamouse mailing lists <[email protected]> wrote: > On Thu, Jan 3, 2013 at 12:34 AM, Hillary Hueter <[email protected]> wrote: >> It was what i put in. It's probably not entirely valid, but i haven't put >> that type of validation into the form yet. >> >> On Wednesday, January 2, 2013 8:44:04 AM UTC-8, tamouse wrote: >>> >>> On Wed, Jan 2, 2013 at 3:57 AM, Rafi A <[email protected]> wrote: >>> > >>> > >>> > 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. >>> >>> Is this valid? >>> >>> >> "date_of_birth"=>"06-15-1086", >>> >>> ?? > > What shows up in your log?
I'm just curious how it works, and how your model is set up. Entering a date value of "06-15-1086" into mysql gives a 0 date. Assuming that's MM-DD-YYYY, mysql needs YYYY-MM-DD unless you do some other munging. (Plus, I'm curious about a birth year 1000 years ago...) -- 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.
