From a51a426b6344fd26d4a1f7bc2d2671ed13231014 Mon Sep 17 00:00:00 2001 From: Mark Newnham Date: Thu, 9 Aug 2018 13:38:31 -0600 Subject: constant ADODB_FORCE_NULL_AND_ZERO not honoured, see #447 Code missing from the _adodb_getupdatesql() method, added --- adodb-lib.inc.php | 14 ++++++++++++++ 1 file changed, 14 insertions(+) (limited to 'adodb-lib.inc.php') diff --git a/adodb-lib.inc.php b/adodb-lib.inc.php index 7034a991..3be0ded4 100644 --- a/adodb-lib.inc.php +++ b/adodb-lib.inc.php @@ -738,6 +738,20 @@ function _adodb_getupdatesql(&$zthis,&$rs, $arrFields,$forceUpdate=false,$magicq $setFields .= _adodb_column_sql($zthis, 'U', $type, $upperfname, $fnameq,$arrFields, $magicq); } break; + case ADODB_FORCE_NULL_AND_ZERO: + + switch ($type) + { + case 'N': + case 'I': + case 'L': + $setFields .= $field->name . ' = 0, '; + break; + default: + $setFields .= $field->name . ' = null, '; + break; + } + break; } //********************************************************// } else { -- cgit v1.3