Course Web Pages - Spring 2012 - LIBR 242-01/10 Greensheet - Sample Codes - xSQL
Sample Stylesheet (.xsl) : xSQL-to-HTML Conversion
<?xml version="1.0"?>
<!-- FAQ-IN-HTML.xsl: Transform ROWSET/ROW format into HTML format -->
<html xsl:version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<head>
<title>Frequently Asked Questions</title>
<style>
td {font-family:verdana,arial; font-size:18;
background-color:#f7f7e7; color:#000000 }
th,table {font-family:verdana,arial; font-size:18;
background-color:#cccc99; color:#336699 }
</style>
</head>
<body>
<center>
<center><h2>Listing of Current Customers</h2></center>
<table border="0">
<tr>
<th>Customer Code</th>
<th>Last Name</th>
<th>First Name</th>
<th>Middle Initial</th>
<th>Address</th>
<th>Phone Number</th>
<th>Balance</th>
</tr>
<xsl:for-each select="ROWSET/ROW">
<tr>
<td>
<xsl:value-of select="CUS_CODE"/>
</td>
<td>
<xsl:value-of select="CUS_LNAME"/>
</td>
<td>
<xsl:value-of select="CUS_FNAME"/>
</td>
<td>
<xsl:value-of select="CUS_INITIAL"/>
</td>
<td>
<xsl:value-of select="CUS_ADDRESS1"/>
</td>
<td>
<xsl:value-of select="CUS_PHONE1"/>
</td>
<td>
<xsl:value-of select="CUS_BALANCE"/>
</td>
</tr>
</xsl:for-each>
</table>
</center>
</body>
</html>
Select here to return to the sample codes page.