My XSP pages which reference the esql logicsheet include
<xsp:page
language="java"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:xsp="http://apache.org/xsp";
xmlns:esql="http://apache.org/cocoon/SQL/v2";
>
.
.
.
</xsp:page>
I suspect you need at least the xmlns:xsp and xmlns:esql attributes.
The semicolon at the end of the esql:query text looks suspicious as well.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 8:19 PM
To: [EMAIL PROTECTED]
Subject: [c2]esql&xsl -newbie q.
Hello,
I'm having some problems with an esql-query, or rather, showing the
query since the error message says the error accurs in the transform
handler.
I've tried to look around a bit how to do the xsl file for an esql
query, but with no luck.So if someone could help me out how to do and
show an esql query I would me much grateful.
This is what I've done so far:
the xsp-file, a simple query who fetches a name from the db:
*********************************************'
<page>
<title>Db Connection Test</title>
<content>
<esql:connection>
<esql:pool>test_mysql_pool</esql:pool>
<esql:execute-query>
<esql:query>
SELECT * FROM flout.namn;
</esql:query>
<esql:results>
<esql:row-results>
<para><esql:get-string column="namn"/></para>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
</content>
</page>
</xsp:page>
*********************************************
the xsl-file, this is probably dead wrong:
*********************************************
<xsl:template match="page">
<html>
<head>
<title><xsl:value-of select="title"/></title>
</head>
<body>
<xsl:for-each select="para">
<p><xsl:value-of select="namn"/></p>
</xsl:for-each>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
*********************************************
And this i added to the sitemap:
*********************************************
<map:match pattern="ctwig/test.xsp">
<map:generate type="serverpages" src="ctwig/test.xsp"/>
<map:transform type="xslt" src="ctwig/test.xsl"/>
<map:serialize/>
</map:match>
*********************************************
Hope someone can help out, been stuck with this basic problem a bit to long.
Cheers,
Marcus.
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
