If i was going to put the date into the correct format, would i do it within the controller or the model?
On Wed, Jan 2, 2013 at 11:29 PM, tamouse mailing lists < tamouse.li...@gmail.com> wrote: > On Thu, Jan 3, 2013 at 1:07 AM, tamouse mailing lists > <tamouse.li...@gmail.com> wrote: > > On Thu, Jan 3, 2013 at 12:34 AM, Hillary Hueter <weimar1...@gmail.com> > 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 <rafi...@gmail.com> wrote: > >>> > > >>> > > >>> > On Wed, Jan 2, 2013 at 1:00 AM, Hillary Hueter <weima...@gmail.com> > >>> > 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"=>"lorem...@gmail.com", > >>> >> "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 rubyonra...@googlegroups.com. > >>> >> To unsubscribe from this group, send email to > >>> >> rubyonrails-ta...@googlegroups.com. > >>> >> 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 rubyonrails-talk@googlegroups.com. > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- 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+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.