var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
can you please help me. I need to get a hierarchical xml output with just one table and 3 columns.
Table looks like this
XML should look like this, so I can easily import data in a treeview
continent country state
Europe Germany Bavaria
Europe Germany Saxony
Europe Switzerland Basel
NorthAmerica USA Texas
NorthAmerica USA Florida
I tried xml auto, raw and explicit. But still no success. You have any idea?
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.