Data Changed by Data Processor


#1

I have created a form which saves a some text.
The “less than” < and anything following it is removed by the data processor.
How can this be fixed so that the < symbol and anything following it is saved in the database?

The data entered on the form is:
SELECT sysdate as “t1” from dual WHERE < 1

The SQL is not important here…it’s just an example, as it is just text.

The logged transaction from the data processor is:

[code]====================================
Log started, 20/03/2017 10:03:36

DataProcessor object initialized
1_dc_id => 2
1_tsql => SELECT sysdate as “t1”
FROM dual
WHERE < 1

1_date_added => 2017-03-17 18:39:45
1_date_modified => 2017-03-20 10:30:39
1_active => Y
1_deleted => N
1_!nativeeditor_status => updated
ids => 1

Row data [1]
dc_id => 2
tsql => SELECT sysdate as “t1”
FROM dual
WHERE
date_added => 2017-03-17 18:39:45
date_modified => 2017-03-20 10:30:39
active => Y
deleted => N
!nativeeditor_status => updated

change value of: date_modified as: 2017-03-20 10:36:36[/code]

Notice the ‘< 1’ has been removed in Row data [1].

Many thanks,

Paul


#2

Check docs.dhtmlx.com/connector__php_ … riptingxss

Set ConnectorSecurity::$xss = DHX_SECURITY_SAFEHTML; to allow HTML tag ( or tag similar text ) in the saved data


#3

Perfect - thank you :slight_smile: