Course Web Pages - Spring 2012 - LIBR 242-01/10 Greensheet - Sample Codes - xSQL

Sample Stylesheet (.xsl) : xSQL-to-XML Conversion


<?xml version = '1.0'?>
<!-- FAQ-IN-XML.xsl: Transform ROWSET/ROW format to 
			CustomerList.dtd vocabulary -->
<xsl:stylesheet version="1.0" 
			xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
   <xsl:output doctype-system="CustomerList.dtd" indent="yes"/>
   <xsl:template match="/">
      <Customer-List>
         <xsl:for-each select="ROWSET/ROW">
            <Customer>
               <ID-Code>
                  <xsl:value-of select="CUS_CODE"/>
               </ID-Code>
               <Last-Name>
                  <xsl:value-of select="CUS_LNAME"/>
               </Last-Name>
               <First-Name>
                  <xsl:value-of select="CUS_FNAME"/>
               </First-Name>
               <Middle-Initial>
                  <xsl:value-of select="CUS_INITIAL"/>
               </Middle-Initial>
               <Address>
                  <xsl:value-of select="CUS_ADDRESS"/>
               </Address>
               <Phone-Number>
                  <xsl:value-of select="CUS_PHONE"/>
               </Phone-Number>
               <Balance>
                  <xsl:value-of select="CUS_BALANCE"/>
               </Balance>
            </Customer>
         </xsl:for-each>
      </Customer-List>
   </xsl:template>
</xsl:stylesheet>

Select here to return to the sample codes page.

Programs

Courses

Sample Stylesheet (.xsl) : xSQL-to-XML Conversion