CCardQuery.xsl

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
                     exclude-result-prefixes="xsl int fs" version="2.0"
                xmlns:fs="http://www.w3.org/2005/xpath-functions"
                xmlns:int="http://www.credit.com/services"
                xmlns:xs="http://www.w3.org/2001/XMLSchema">
    <xsl:output encoding="utf-8" indent="yes" method="xml"/>
    <xsl:template match="/">
        <xsl:apply-templates select="/RowSet/data/row"/>
    </xsl:template>
    <xsl:template match="/RowSet/data/row">
        <xsl:element name="QueryResponse" namespace="http://www.credit.com/services">
            <xsl:element name="name" namespace="http://www.credit.com/services">
                <xsl:value-of select="col[1]"/>
            </xsl:element>
            <xsl:element name="cnumber" namespace="http://www.credit.com/services">
                <xsl:value-of select="col[2]"/>
            </xsl:element>
            <xsl:element name="credit" namespace="http://www.credit.com/services">
                <xsl:value-of select="col[3]"/>
            </xsl:element>
            <xsl:choose>
                <xsl:when test="col[4] = 'Y'">
                    <xsl:element name="active" namespace="http://www.credit.com/services">
                        <xsl:value-of select="'true'"/>
                    </xsl:element>
                </xsl:when>
                <xsl:otherwise>
                    <xsl:element name="active" namespace="http://www.credit.com/services">
                        <xsl:value-of select="'false'"/>
                    </xsl:element>
                </xsl:otherwise>
            </xsl:choose>
        </xsl:element>
    </xsl:template>
</xsl:stylesheet>