/** * U P D A T E */ function doUpdate() { /* test if all keycolumn values are set */ $uq = new UpdateQuery($this->dbConn, $this->relation); $uq->setKeyColumns($this->keyColumns); /* refill menu from post data */ /* done in processResponse $this->menu->setMenuValues($_POST); */ $this->menu->prepareForUpdate($this->dbMessage); $cnames = $this->menu->getColumnNames(); $arr = $this->menu->getColumnValues($cnames); $uq->setSubmitValueSet($arr); $uq->setUpdateSet($arr); if ($uq->areKeyColumnsSet()) { /* allow update */ $query = $uq->getQuery(); $result = doUpdate($this->dbConn, $query, $this->dbMessage); //$this->dbMessage .= $result . ' row(s) updated ' . $this->dbMessage; } else { $this->dbMessage .= "\n" . 'DB ERROR: Update failed.<br>Not all keyColumns have been set'; } }