OK the actual XML that is going into the failing XSL is as follows:
<user>
<detail>
<name>tomplace</name>
<password>tom</password>
<first>tom</first>
<last>place</last>
</detail>
<existing-user>
<rowset />
</existing-user>
</user>
The fact that the existing user rowset is empty is a good thing (if it
wasn't empty then something else happens that works!
The xsl that fails is as follows:
<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:sql="http://apache.org/cocoon/SQL/2.0">
<xsl:template match="user">
<page>
<xsl:choose>
<xsl:when test="existing-user/sql:rowset/sql:row">
<title>Blah</title>
</xsl:when>
<xsl:otherwise>
<execute-query xmlns="http://apache.org/cocoon/SQL/2.0">
<query>
insert into user_info (USERNAME) values (<xsl:value-of
select="detail/name"/>)
</query>
</execute-query>
<title>Blah 2</title>
</xsl:otherwise>
</xsl:choose>
</page>
</xsl:template>
</xsl:stylesheet>
-----Original Message-----
From: Luca Morandini [mailto:spectrum.morandini@;ipzs.it]
Sent: 28 October 2002 15:27
To: [EMAIL PROTECTED]
Subject: R: Cocoon SQL Transformation
Tom,
I guess your pipeline contains a couple XSLT transformations and a
couple
SQL ones (one for the select, one for the insert), isn't it ?
If this is true, could you please send me the XML which is sent to the
failing transformation (be it SQL or XSLT) ?
I'm interested in the actual XML document going into the transformer,
not in
the XSL source code.
Best regards,
Luca Morandini
Istituto Poligrafico e Zecca dello Stato
[EMAIL PROTECTED]
[EMAIL PROTECTED]
We are protected from the virus by Norton Antivirus Corporate
Edition
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.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/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>