XLST tranformation to HTML

42 Views

Hi Experts...

I wanna know if exists a transformation to put the result of

one SQL Call into a HTML Table....

I have the next code:

<xsl:template name="transform">
  <xsl:attribute name="pltype">htm</xsl:attribute>
  <FileOut xmlns="" type="file">
       <html>
       <body>
            <table border="1">
                 <tr bgcolor="#9acd32">
                      <th style="text-align:left">ID LLAMADA</th>
                      <th style="text-align:left">Fecha de Creación</th>
                      <th style="text-align:left">Fecha de Resolución</th>
                 </tr>
                <xsl:for-each select="/vpf:Msg/vpf:Body/vpf:Payload[./@id='atom1']/jdbc:ResultSet/jdbc:Row">
                 <tr>
                      <td><xsl:value-of select="./jdbc:callID"/></td>
                      <td><xsl:value-of select="./jdbc:createDate"/></td>
                      <td><xsl:value-of select="./jdbc:closeDate"/></td>
                 </tr>
                 </xsl:for-each>
           </table>
       </body>
       </html>
  </FileOut>
</xsl:template>

But the transformation does not work:

Thanks...

Best regards

Enrique.

Attachments

salida.JPG (36.9 kB)