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
What is the executed SQL? Look at your development log.
–
Dheeraj K.
On Wed, Jan 2, 2013 at 1:00 AM, Hillary H. [email protected]
wrote:
“middle”=>“Lorem”,
“date_of_birth”=>“06-15-1086”,
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.
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 Thu, Jan 3, 2013 at 12:34 AM, Hillary H. [email protected]
wrote:
“first”=>“Ipsum”,
“expiration”=>“06-15-2015”,
To unsubscribe from this group, send email to
and
then store the parsed value in database.
Is this valid?
“date_of_birth”=>“06-15-1086”,
??
What shows up in your log?
On Thu, Jan 3, 2013 at 1:07 AM, tamouse mailing lists
[email protected] wrote:
wrote:
“pilgrim”=>{“surname”=>“Lorem”,
“passport_number”=>“123455”,
“commit”=>“Save”}
To post to this group, send email to [email protected].
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…)
On Wed, Jan 2, 2013 at 3:57 AM, Rafi A [email protected] wrote:
“authenticity_token”=>“3njnNBX4VgoV32kau3OALfhdIP00Bq78we6EKD7OXHo=”,
“nationality”=>“USA”,
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”,
??
i think this had something to do with the type of the date_of_birth
column.
I’ve changed it from datetime to date. and it seems to be working.
On Thu, Jan 3, 2013 at 2:06 AM, weimar [email protected] wrote:
If i was going to put the date into the correct format, would i do it within
the controller or the model?
If you consider that a valid form of date (which it is), then doing
the manipulation to make it work in the model should go in the model,
notably using a before_save hook.
OTOH, if you accept any sort of string in that field, you will
probably need to validate it’s contents before passing it off to the
model, and that should go in the controller.
OTOOH, put it where it makes the most sense to you.
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 <
ok. thanks.
On Thu, Jan 3, 2013 at 7:24 PM, tamouse mailing lists <