cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dean Cording <>
Subject SQLTransformer not committing Inserts
Date Mon, 15 Sep 2003 23:22:55 GMT
I am having some problems with SQLTransformer not commiting inserts into a
database.  I am running Cocoon 2.1 and MS SQLServer.
My pipeline looks like:
               <map:match pattern="CodeCreate-add">
                    <map:generate type="request"/>
                    <map:transform type="xslt" src="CodeAddTest.xsl">
                        <map:parameter name="use-request-parameters"
                    <map:transform type="sql">

                        <map:parameter name="use-connection"
                        <map:parameter name="show-nr-of-rows" value="true"/>

                        <map:parameter name="isupdate" value="true"/>
                    <!-- Redirect back to the table display page -->
                    <map:redirect-to uri="CodeTableList"/>

And CodeAddTest.xsl looks like:
<xsl:stylesheet version="1.0" xmlns:xsl=" <>
<> ">
    <xsl:param name="CodeType"/>
    <xsl:param name="CodeValue"/>
    <xsl:template match="/">
        <execute-query xmlns="
<> ">
                INSERT INTO Codes (CodeType, CodeValue)
                VALUES ('<xsl:value-of select="$CodeType"/>', '<xsl:value-of

The values to be inserted are generated from a form and passed in as request
parameters.  At the end of the pipeline it redirects to a list page that
shows all of the values in the database.  The problem is that the new values
aren't being inserted.  If I remove the redirect (and replace it with a
static page for example) then the insert works fine.
Any ideas?

View raw message