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
