OK I have got it working!!
But its not coming out in the correct table format, e.g. -------------------------------------------- The result im getting is: ParachutesWhats The Story Morning Glory Coldplay Oasis -------------------------------------------- The result I want: Coldplay Parachutes Oasis The Story Morning Glory -------------------------------------------- I have attached my xsl, what can anyone suggest? Thanks, Richard.
<?xml version="1.0" encoding="UTF-8"?> <!-- Produced by Richard Cunliffe, Liverpool, UK - Last updated 12-March-2003 --> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; xmlns:sql="http://apache.org/cocoon/SQL/2.0";> <xsl:output method="html"/> <xsl:template match="document"> <html> <head> <title>Soundpool - Database</title> <img src="/soundpool/images/backgroundpda.jpg"/> <br/> <br/> <table border="0" width="99%"> <tbody> <tr> <td align="center" width="3.8%"> <a href="c.html"> <span style="color:#2B4E71; font-family:Verdana; font-size:8pt">c</span> </a> </td> <td align="center" width="3.8%"> <a href="o.html"> <span style="color:#2B4E71; font-family:Verdana; font-size:8pt">o</span> </a> </td> </tr> </tbody> </table> <br/> <table border="0" width="99%"> <tbody> <tr> <td align="center" colspan="1"> <span style="color:#325B85; font-family:Verdana; font-size:12pt"><xsl:value-of select="database"/></span> </td> </tr> </tbody> </table> </head> <br/> <!--MAIN BODY--> <body> <!-- database results in table --> <table> <xsl:apply-templates select="sql:rowset/sql:row"/> </table> </body> </html> </xsl:template> <xsl:template match="sql:row"> <tr> <xsl:apply-templates/> </tr> </xsl:template> <xsl:template match="sql:artistbandname|sql:generalmusictrack"> <td> <xsl:value-of select="."/> </td> </xsl:template> </xsl:stylesheet>
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
