This is a http link through a query from SQL 2000, and then use the getUrl parse the xml file in the creator, the format is the basic reference creator to help complete the test data seems crawl, but can not display the data and found a different format, as follows

1，the sample from zoho creator

2，the sample from my link

Grab the data format is as follows：

my function code as  follows：

2. string test()
3. {
4.     sm = "<table class=table zc-viewtable>" + "<tr class=zc-row-header>" + "<td class=zc-viewrowheader colspan=5>" + "<center>Display data From SQL 2000</center>" + "</td>" + "<tr class=zc-row-header>" + "<td class=zc-viewrowheader>" + "Address" + "</td>" + "<td class=zc-viewrowheader>" + "Phone No" + "</td>";
5.     mapvar = getUrl(("http://182.151.69.181/getdata?sql=SELECT * FROM CUSTOMERS FOR XML AUTO&root=root"),false);
6.     stringdata = mapvar.get("responseText");
7.     xmldata = stringdata.toXML();
8.     strdata = xmldata.executeXPath("/root/CUSTOMERS");
9.     strdata = (strdata).replaceAll("&","and");
10.     xmllist = strdata.toXmlList();
11.     for each r in xmllist
12.     {
13.         sm = sm + "<tr>" + "<td>" + r.executeXPath("/CUSTOMERS/@Address") + "</td>" + "<td>" + r.executeXPath("/CUSTOMERS/@Phone") + "</td>";
14.     }
15.     sm = sm + "</table>";
16.     return sm;
17. }

this link is working

http://182.151.69.181/getdata?sql=SELECT * FROM CUSTOMERS FOR XML AUTO&root=root

so could you please help me check where is problem in my function or the link format.

Thanks and waiting your reply

Stnaley Guo

2012-3-26