cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gapinski, Gary (GEL, MSX)" <Gary.Gapin...@lighting.ge.com>
Subject RE: [c2]esql&xsl -newbie q.
Date Fri, 04 Jan 2002 11:47:31 GMT
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: marka632@student.liu.se [mailto:marka632@student.liu.se]
Sent: Thursday, January 03, 2002 8:19 PM
To: cocoon-users@xml.apache.org
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>

---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message