Hi,
I am using the sql transformer. I have the problem that the resulting xml is
missing the xmlns:sql declaration.
I call it this way
<map:match pattern="userUris">
<map:generate src="sql/userUri.xml" />
<map:transform type="sql">
<map:parameter name="use-connection"
value="vedanova" />
<map:parameter name="show-nr-of-rows"
value="true"/>
<map:parameter name="clob-encoding"
value="UTF-8"/>
<map:parameter name="userId" value="1"/>
</map:transform>
<map:transform type="xslt-saxon"
src="stylesheets/userUri2IncludeXml.xslt"/>
<map:serialize type="xml" />
</map:match>
thats my query file
<page>
<sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0";>
<sql:query name="user">
select u.uri, u.description_de from uris u, userUri v where u.id =
v.id_uri and v.id_user =
'<sql:substitute-value name="userId"/>'
</sql:query>
</sql:execute-query>
</page>
and the result
<page>
<sql:rowset nrofrows="2" name="user">
<sql:row>
<sql:uri>
http://www.google.com/
</sql:uri>
<sql:description_de>Christophs Privater Kalender</sql:description_de>
</sql:row>
</sql:rowset>
</page>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
