HTMLEditor and | in insert and update transactions.
How can I easily handle the | character as input in HTMLEditor. In the insert and update transactions it breaks the behavior, and when I added it as a character to encode, the input was completely corrupted.
I can add this code to the page, but I should not have to do this every time I use the editor for insert or update. I suggest that this is not a good separator for Data Assist to use, or DA should encode this character before adding the value to the SQL preparation and decode this character in the SQL statement as part of its routine.
<?php
// encode vertical bars
foreach ($_POST as $key => $value) {
$_POST[$key] = str_replace("|", "&#124;",$value);
}
?>
(I fixed the character rendering, thanx)