insert NULL or empty string to datetime column
I'm trying to get my insert to insert NULL or and empty string when the $_POST["checkin_open_date"]." ".$_POST["checkin_open_time"] or $_POST["checkin_close_date"]." ".$_POST["checkin_close_time"] is left blank on the form. I've tried WA_BLANK and WA_NULL, but niether of them seem to be working. Any idea what I'm doing wrong here? I'm attaching a screenshot of the table structure so you can see that the default value for the columns is set to default to NULL. I've also tried WA_DEFAULT, but no luck there either. The only thing I can think of is it's the concatenating, but I didn't know if that would matter.
<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$InsertQuery = new WA_MySQLi_Query($local_i);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "schedule_event_checkin";
$InsertQuery->bindColumn("schedule_id", "i", "".((isset($_GET["schedule_id"]))?$_GET["schedule_id"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("checkin_open_date", "t", "".((isset($_POST["checkin_open_date"])." ".isset($_POST["checkin_open_time"]))?$_POST["checkin_open_date"]." ".$_POST["checkin_open_time"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("checkin_close_date", "t", "".((($_POST["checkin_close_date"])." ".($_POST["checkin_close_time"]))?$_POST["checkin_close_date"]." ".$_POST["checkin_close_time"]:"") ."", "WA_DEFAULT");
$InsertQuery->saveInSession("");
$InsertQuery->execute();
$InsertGoTo = "";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>