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