Is there a way to load data with ampersand charcater in it.
We have clinets with ampersand as part of the client name field.
The grid.loadXML(“file.XML”) method failes with the following message:
Error type: LoadXML
Description: Incorrect XML
When ampersand is removed the file loads fine.
If this character needs to be escaped what is the correct escape syntax?
The XML which you load must have valid syntax.
By XML rules the & char is depricated, it must be replaced with
& => &
Also please beware that HTML based column types ( all except rotxt and edtxt ) will threat ampersand by HTML rules, so you may need to do double escaping