static function insert($this1, $table, $columns = null) { $str = "INSERT INTO " . Std::string($table); if ($columns !== null) { $str .= " (" . _hx_string_or_null(zcale_sys_db_SqlTools::joinColumns($columns)) . ")"; } return $str; }
static function joinValues($values) { $str = ""; $_g = 0; while ($_g < $values->length) { $v = $values[$_g]; ++$_g; $str .= "," . _hx_string_or_null(zcale_sys_db_SqlTools::evalValue($v)); unset($v); } return _hx_substr($str, 1, null); }
public function updateRecords() { $naw = new zcale_sys_db_tests_zcale_Naw(); $sql = null; $this1 = null; $this2 = null; $this3 = null; $this4 = null; $this4 = zcale_sys_db_tests_DatabaseTest_3($this, $naw, $sql, $this1, $this2, $this3, $this4); $str1 = _hx_string_or_null($this4) . " SET " . Std::string($naw->naam) . "=" . _hx_string_or_null(zcale_sys_db_SqlTools::evalValue("Martinez Martinez")); $this3 = $str1; $str2 = _hx_string_or_null($this3) . " WHERE " . Std::string($naw->naam); $this2 = $str2; $str3 = _hx_string_or_null($this2) . "=" . _hx_string_or_null(zcale_sys_db_SqlTools::evalValue("Martinez")); $this1 = $str3; $sql = $this1; $this->cnx->request($sql); Sys::hprint("<br/>Record updated in " . Std::string($naw) . ": " . _hx_string_or_null($sql)); }