I have created an update query and I am receiving incorrect INTEGER value: upon submit. I have tried everything I can to correct but cannot find a solution.
Here is the update query:
<?php
if (isset($_POST["submit"]) || isset($_POST["submit_x"])) {
$UpdateQuery = new WA_MySQLi_Query($MTS_i);
$UpdateQuery->Action = "update";
$UpdateQuery->Table = "transport_location";
$UpdateQuery->bindColumn("Record_ID", "i", "", "WA_DEFAULT");
$UpdateQuery->bindColumn("Transportnumber", "s", "".($Recordset1->getColumnVal("Transportnumber")) ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("location", "s", "".($Recordset1->getColumnVal("location")) ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("Date", "t", "".($Recordset1->getColumnVal("Date")) ."", "WA_DEFAULT");
$UpdateQuery->addFilter("Record_ID", "=", "i", "".($Recordset1->getColumnVal("Record_ID")) ."");
$UpdateQuery->execute();
$UpdateGoTo = "update_locations.php";
if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):"";
$UpdateQuery->redirect($UpdateGoTo);
}
?>