Generic XML Style Sheet

HardcoreTechnoHead · Feb 25, 2003

I have an audit table in a SQL database which keeps the actual audit data for all operations in XML format something like

<TABLENAME>
<NEW>
<COL1>value</COL1>
<COL2>value</COL2>
</NEW>
<OLD>
<COL1>value</COL1>
<COL2>value</COL2>
</OLD>
</TABLENAME>

I need ot be able to report on the audit trail and can very easily get to the data and dynamically build the reports.

As each table has a different layout/column names so the XML output generated is different for each table.

Basically, when the report renders in IE5, the output is very confusing for the users who do not read XML. Therefore it would be easier if I could produce an output in the form

TableName
New
Col1 Value
Col2 Value

Old
Col1 Value
Col2 Value

Any ideas how this can be achieved? It must be possible as Microsoft can do something similar in IE5 (even if it is not pretty IMHO =))
Andie Harper
"If you can keep your head when all around you have lost theirs, you probably haven't understood the seriousness of the situation"

palbano · Feb 25, 2003

i'm not real clear on your problem/goal statement. best as i can tell it seems reasonable. have u used or research XSLT at all yet?

-pete

HardcoreTechnoHead · Feb 25, 2003

I've been reading around but have not yet got past the barrier that you need to know the elemnt name up form the product the style sheet.

As I have approximatley 50 tables, If I need to know the element name I would have to write 50 style sheets. I sure it must be possible through a single stylesheet, but cannot yet find what I need to know to do it.

I'm relatively new to this topic Andie Harper
"If you can keep your head when all around you have lost theirs, you probably haven't understood the seriousness of the situation"

HardcoreTechnoHead · Feb 25, 2003

Found my own solution Andie Harper
"If you can keep your head when all around you have lost theirs, you probably haven't understood the seriousness of the situation"

HardcoreTechnoHead · Feb 25, 2003

<xsl:stylesheet xmlns:xsl="

http://www.w3.org/1999/XSL/Transform"

version="1.0">
<xsl

utput method="html"/>


<xsl:template match="text()"/>

<xsl:template match="/">
<html>
<head>
<META HTTP-EQUIV="Expires" CONTENT="0"></META>
<link rel="stylesheet" type="text/css" href="../styles/styles.css" media="print"></link>
</head>
<body>
<xsl:apply-templates/>
</body>
</html>
</xsl:template>

<xsl:template match="//*">
<xsl:element name="H1">
<xsl:value-of select='name()'/>
</xsl:element>
<xsl:apply-templates/>
</xsl:template>

<xsl:template match="//*/*">
<table width="60%" cellspacing="0" cellpadding="0" border="0">
<tr>
<td colspan="2" class="Head">
<xsl:value-of select='name()'/>
</td>
</tr>
<xsl:apply-templates/>
</table>
</xsl:template>

<xsl:template match="//*/*/*">
<tr>
<td width="25%" class="Body"><strong><xsl:value-of select='name()'/>:</strong></td>
<td width="*" class="Body"><xsl:value-of select='text()'/></td>
</tr>
<xsl:apply-templates/>
</xsl:template>

</xsl:stylesheet> Andie Harper
"If you can keep your head when all around you have lost theirs, you probably haven't understood the seriousness of the situation"

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Generic XML Style Sheet

HardcoreTechnoHead

Technical User

palbano

Programmer

HardcoreTechnoHead

Technical User

HardcoreTechnoHead

Technical User

HardcoreTechnoHead

Technical User

Similar threads

Part and Inventory Search

Sponsor