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]>