Do not update if no value in input or update as NULL to Date field IF empty

Hello,
I have a simple input using Jquery Datepicker, MySQL Date field with a NULL allowed.

Can't get a blank entry to leave the NULL or Update as NULL when no data / values is selected / present.

Tried:
$UpdateQuery->bindColumn("birthday", "t", "".((isset($_POST["datepicker"]))?$_POST["datepicker"]:"") ."", NULL);

$UpdateQuery->bindColumn("birthday", "t", "".((isset($_POST["datepicker"]))?$_POST["datepicker"]:"") ."", "WA_IGNORE");

$UpdateQuery->bindColumn("birthday", "t", "".((isset($_POST["datepicker"]))?$_POST["datepicker"]:"") ."", "WA_NULL");

Everytime the DB sets "1969-12-31" as the value when the field is empty.


Anyway to leave the Default NULL alone unless there really is a value being set?

It looks like there is a bug in the code.

Update this section in the queryobj.php file:

$paramValue = strtotime($paramValue);

        if ($hasTime) {

          $paramValue = date('Y-m-d H:i:s',$paramValue);

        } else {

          $paramValue = date('Y-m-d',$paramValue);

        }

and wrap it in an IF statement like:

if ($paramValue) {

          $paramValue = strtotime($paramValue);

          if ($hasTime) {

            $paramValue = date('Y-m-d H:i:s',$paramValue);

          } else {

            $paramValue = date('Y-m-d',$paramValue);

          }

                }

The code that we have to update the syntax of date columns to a format that MySQL recognizes is still running even when no value is entered and causing this problem.

That works Ray. Thanks!

Gonna need to update your Behavior soon so everyone gets all these little tweaks and bug fixes.