Forums

esccaping issue on NULL in data read condition

Collie-IT 12 Sep, 2020
[div wfd-id="61"]Dear support,

it theams to be in posible to make a
xx IS NULL

Condition because the escaping escapes wrongly NULL to
xx IS ' NULL'

As hotfix it is posible to add on \wp-content\plugins\chronoforms7\chronog3\admin\extensions\chronofc\libs\models.php line 367 ff following code
 if($condition['value'] == ' NULL' ){
$condition['value'] = NULL;
}
Best Regarts
Collie-IT
Max_admin 16 Sep, 2020
No, in the value field use {const:Null} and that will work!
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
This topic is locked and no more replies can be posted.