Xml

silas · #1 (**permalink**) 07-20-07, 04:50

Hello,

can you please help me. I need to get a hierarchical xml output with just one table and 3 columns.

Table looks like this

Code:

continent       country   state
Europe           Germany    Bavaria
Europe           Germany    Saxony
Europe           Switzerland   Basel
NorthAmerica      USA     Texas
NorthAmerica      USA     Florida

XML should look like this, so I can easily import data in a treeview

Code:

Europe
    Germany
       Bavaria
       Saxony
    Switzerland
       Basel
Northamerica
   USA
      Texas
      Florida

I tried xml auto, raw and explicit. But still no success. You have any idea?

anjanesh · #2 (**permalink**) 07-26-07, 08:24

Are you sure this is possible using SQL alone ?
You can easily do this using some programming languages like php/python to display this XML.

Internet Services

Web Development

Digital Marketing

Consumer Tech