This topic is locked

null date

10/19/2012 6:31:19 AM
PHPRunner General questions
C
cjsaputo author

I have multiple date fields and on the add page I cannot save record without entering a date in all. How can I allow null dates?

Sergey Kornilov admin 10/19/2012

Make sure field is setup in the database as NOT NULL or make it required in PHPRunner so user has to enter the value.

C
cjsaputo author 10/20/2012



Make sure field is setup in the database as NOT NULL or make it required in PHPRunner so user has to enter the value.


Sergey, The fields are set as NULL and are not required because I want the user to be able to leave the field blank. Maybe I don't understand the use of NULL and NOT NULL.

Sergey Kornilov admin 10/20/2012

My mistype, I meant to say set field to allows NULLs.
What exactly "I cannot save record without entering a date" means? Any error messages?

C
cjsaputo author 10/22/2012



My mistype, I meant to say set field to allows NULLs.
What exactly "I cannot save record without entering a date" means? Any error messages?


If I leave any of the date fields blank and click save the red message at the top of the screen tells me that the date field cannot be blank. This happens on all date fields. I have tested by entering a date in one field at a time and the error happens on each save until I have entered a valid date in each field.

Sergey Kornilov admin 10/22/2012

What's the exact error message?