Data from 2 separate databases. Need advice

Suite and Optimus Suite 5
#1

Hello Guys

We provide a web portal service for our clients that use our desktop software. We interact with the local database for the software using PHP and an appropriate extension for the database engine however we have run into an issue.

We have one client that has 2 separate versions of our desktop application and we need to show both in the grid. This has to be done with 2 separate queries as they are in 2 totally different database locations.

This works great, however none of the data is sorted.

My question is this. Is there a way to force the dhtmlxGrid to sort itself after the data has been loaded from the generated XML?

#2

Yep, sure

grid.load(url, function(){ grid.sortRows(...); });

docs.dhtmlx.com/doku.php?id=dhtm … sortrows&s[]=sortRows

If you need to load data from multiple datasources you can use

grid.load(url1, function(){ grid.load(url2, function(){ grid.sortRows(...); }); });

#3

I have the datasets being combined by PHP into one file that spews out XML.

Many thanks for pointing out this sort function to me though, I shall implement it shortly.