From c94f5d249f9ab095a7275eb67a5e17c69d0acb9a Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Thu, 16 Mar 2017 12:26:29 +0000 Subject: [PATCH] lib/php/db/table.php --- lib/php/db/table.php | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/lib/php/db/table.php b/lib/php/db/table.php index 641b05e1..ea9fa255 100644 --- a/lib/php/db/table.php +++ b/lib/php/db/table.php @@ -690,9 +690,10 @@ Class Table extends nb { $equal = ' '.($not ? 'NOT ' : '').$regexp.' '; // Text - } elseif (preg_match('/text|char|blob/',$field->type) - or ($v!='null' and !preg_match('/^\d+(\.\d*)?$/',$v)) # text criteria value - ) { +# NB 16.03.17 } elseif (preg_match('/text|char|blob|date/',$field->type) +# NB 16.03.17 or ($v!='null' and !preg_match('/^\d+(\.\d*)?$/',$v)) # text criteria value +# NB 16.03.17 ) { + } elseif ($field->string()) { if (strtolower($v)=='null') $v = ''; #$k = "COLAESCE($k,'')"; -- 2.47.3