Grid displaying XML - issue in FireFox

Suite and Optimus Suite 5
#1

Last week I downloaded dhtmlxSuite, and successfully ran through the sample posted at: docs.dhtmlx.com/doku.php?id=tuto … serverside

Everything worked fine, until I loaded the table referenced by the Grid with a larger set of data from a different source of mine (just happened to be my PayPal data from last year). The issue is that when I display the grid I get a popup (image attached) showing the XML for the first 19 rows (ex. <?xml version='1.0' encoding='utf-8' ?><![CDATA[US Postal Service…and on and on).

I assumed it was some funky character issue, but here’s where it gets strange… I loaded the table with my data in smaller chunks at a time (to try and isolate where the errant character may be); viewing the Grid; then loading more data; repeated until I ended up with all the data loaded in the table, and the Grid worked fine. So, maybe not a character issue? I then truncated the table again and loaded it up with all several hundred records, and ran into the issue again.

After searching and searching around here on the Forums I saw some messages indicating this might be a browser issue related to the handling of certain characters, with FireFox being more sensitive to this. After trying the Grid out with the fully loaded table in a couple other browsers (Chromium, Epiphany, Chrome), I now see this works fine in all except FireFox.

My main question in all this is “What is the general issue when the XML starts displaying?”. I’m still thinking it’s a character issue? Maybe with FireFox being more sensitive to this?

Thanks in advance for any pointers.

popup.png1107×448 74.3 KB

#2

Update… With the nagging suspicion this issue is due to FireFox and the handling of funky characters, this morning I decided to eliminate the “Description” column data from the table being referenced in the Grid. The Description column is the only one that potentially has any funky characters in it, so I just nulled out all the data in that column. Once I did that, the Grid now displays fine in FireFox.

Guess I’ll go back to my data parsing and table loading scripts and add some data cleansing routines.

#3

My main question in all this is “What is the general issue when the XML starts displaying?”. I’m still thinking it’s a character issue? Maybe with FireFox being more sensitive to this?

You’re right. Most probably it is a character issue. The easiest way to check your xml - is open it in the needed browser. In most cases browser will point you to the problematic char.