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.
