cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Diego Moller" <>
Subject Nothing when using sql-tag lib
Date Fri, 23 Jun 2000 12:05:22 GMT
Hi All,

I seem to have run into some quite bizarre problems.

I'm using cocoon v.1.7 together with mysql on an NT-workstation with Apache 
and have made a little test-code to check that the sql-tag-lib with xsp 
works and it does (perfectly actually). Now i have tried to port the same 
code and the exact same versions to a linux environment and here I run to a 
strange problem. It seem that cocoon doesn't execute the sql-query!?

Here is the code I've made

<?xml version="1.0"?>
<?cocoon-process type="xsp"?>
<?cocoon-process type="xslt"?>
<?xml-stylesheet href="simple-taglib-html.xsl" type="text/xsl"?>


<title>Cocoon XSP SQL TagLibs </title>
  <name>Nicki Moller (stjaalet fra Stefano Mazzocchi og Brian Millet)</name>

    Cocoon's SQL/XSP tag library. Samt en lille liste i XSL</p>



   <sql:query>SELECT * FROM Users;</sql:query>



<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="">

  <xsl:template match="page">
         <xsl:value-of select="title"/>
<!-- Changed by: D.K.S., 02-Mar-2000 -->
    <body bgcolor="#ffffff">



<xsl:template match="title">

<xsl:template match="p">

<xsl:template match="a">
     <a href="{@href}"><xsl:apply-templates/></a>

<xsl:template match="author">
  Lavet af

<xsl:template match="name">

<xsl:template match="ROWSET">

Query: <xsl:value-of select="@sqlquery"/>
  Der er  <xsl:value-of select="@count"/> entries i databasen.

    <table border="2" cellspacing="1" cellpadding="6">
     <xsl:for-each select="ROW">
      <td><xsl:value-of select="Name"/></td>
      <td><xsl:value-of select="NickName"/></td>
      <td><xsl:value-of select="Email"/></td>
      <td><xsl:value-of select="User"/></td>
      <td><xsl:value-of select="Passwd"/></td>
      <td><xsl:value-of select="Server"/></td>
    <p>Hurraaaaa det virker ogsaa!!!</p>



And here is the result I get

Cocoon XSP SQL TagLibs
Lavet af Nicki Moller (stjaalet fra Stefano Mazzocchi og Brian Millet)
Cocoon's SQL/XSP tag library. Samt en lille liste i XSL jdbc:mysql://localhost:3306/diego diego none 0 20 y 
count sqlquery ROWSET ROW SELECT * FROM Users

When I in fact should have had a list of the User tables content

My very simple question is this:
Is it me who have forgotten something in the test-code or is it in my 
cocoon-configuration I have made an error???

PS. I'm a newbie in all of this cocoon/xml/xsl/xsp so please take this into 
account when answering 8-)

Thanx in advance

Get Your Private, Free E-mail from MSN Hotmail at

View raw message