I have an XML structure that represents a shopping cart's columns and rows. However the incoming XML has Rows as child-elements of each Column element. We are trying to use XSL to display the shopping cart based on this XML.
The current XML (in a database column- MS SQL Server 2000) looks like this:
It does not matter where the transpose could be available (either as a DB function on SQL server or a XML Dom function or in XSL or any other). Any help would be really appreciated.
The overall goal is to loop through the xml using XSL (for-each) to display the items and render a shopping cart application. So if I have row based XML data (rather than column based), looping and rendering will be much easier (a straight parse). Thanks for all your help.