XSL transformation of database results in XML

Insomniak

New Member
I am being provided with an XML format of the results from a DB query and need to apply XSL to transform the XML into an HTML table format. I'm a novice at XSLT and after much searching, I can't seem to find a good example that matches the format of my XML.My XML looks like this:\[code\]<?xml version="1.0" encoding="UTF-8"?><B1j:jdbcQueryResult xmlns:B1j="http://ns.b1tech.com/2012/08/jdbc-query-result"> <B1j:row> <B1j:col name="response_size" type="java.lang.Integer">128837</B1j:col> <B1j:col name="groupname" type="java.lang.String">AAA</B1j:col> <B1j:col name="count_total" type="java.lang.Integer">1</B1j:col> <B1j:col name="count_error" type="java.lang.Integer">0</B1j:col> <B1j:col name="timestamp" type="java.lang.Long">1363654726298</B1j:col> <B1j:col name="count_success" type="java.lang.Integer">1</B1j:col> </B1j:row> <B1j:row> <B1j:col name="response_size" type="java.lang.Integer">128837</B1j:col> <B1j:col name="groupname" type="java.lang.String">BBB</B1j:col> <B1j:col name="count_total" type="java.lang.Integer">1</B1j:col> <B1j:col name="count_error" type="java.lang.Integer">0</B1j:col> <B1j:col name="timestamp" type="java.lang.Long">1363654757598</B1j:col> <B1j:col name="count_success" type="java.lang.Integer">1</B1j:col> </B1j:row></B1j:jdbcQueryResult>\[/code\]Any one that can help me with what my XSLT template should look like to exact the column names and the values from this XML and put into a basic HTML table?Thanks in advance!!
 
Back
Top