Start Building Professional
Web Apps Today

dhtmlxGrid (working with PostgreSQL)

Hi,

I am attempting to use dhtmlxGrid in order to get data from a PostegreSQL DB. Now I am able to get the data from the DB, and I am successfully converting it to XML. And I got it working happily off a test table.

However when I tried to query my main table I keep getting an error of "Incorrect XML"

Here is a sample row of my XML that is outputted by my php file that is querying the DB:

<?xml version="1.0" encoding="UTF-8"?>
<rows>
<row id="1">
<cell>1</cell>
<cell></cell>
<cell></cell>
<cell></cell>
<cell></cell>
<cell></cell>
<cell>TR</cell>
<cell></cell>
<cell></cell>
<cell>f</cell>
<cell>2.79522e+06</cell>
<cell>6.33312e+06</cell>
<cell>Airport Direction (pictorial)</cell>
<cell>Photos\Fenton St (Small)\Fenton St-1.JPG</cell>
<cell></cell>
<cell>t</cell>
<cell>2008-01-25 10:57:44.687691+13</cell>
<cell>SYSADM</cell>
<cell>10:57:44.687691+13</cell>
<cell>SYSADM</cell>
<cell>Fenton St</cell>
<cell>Sala Street</cell>
</row>
</rows>

What am I doing wrong with this?

Kind Regards
Roger

There is no any problem with used XML - it is correct and works fine while loading from static XML file.
Please be sure that server side script
 - set correct content type - text/xml
 - there is no whitespaces before xml header <?xml ...

Also you can try to use attached js file instead of original dhtmlxcommon.js - it shows all fetched data, so if any problem occurs with server side script - it will be easy to detect it.

I found the problem, I needed to put a htmlspecialchars clause around some of my strings as they contained things that the loadXML didn't like