SLIS A-Z Index
People Search
SLIS Calendar

Programs

Courses

Textbooks by Semester

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.