Tom, what about adding a couple quotes around the username value ?
Something like: insert into user_info (USERNAME) values ('<xsl:value-of select="detail/name"/>') Best regards, P.S. Mind ! Strings may contain unmatched single quotes, which greatly offend the SQL parser, think about converting unmatched single quotes in matched ones ("'" --> "''") before sending SQL statements to the SQLTransformer. Luca Morandini [EMAIL PROTECTED] > -----Messaggio originale----- > Da: Tom Place [mailto:psyttrp@;nottingham.ac.uk] > Inviato: luned́ 28 ottobre 2002 18.19 > A: [EMAIL PROTECTED] > Oggetto: RE: Cocoon SQL Transformation > > > 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]> > 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]>