You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by I-Lin Kuo <ik...@hotmail.com> on 2003/02/05 22:02:49 UTC
SQLtransformer repeats namespace
Running Cocoon 2.04 on Tomcat 4 on Apache 2 on Windows XP with JDK 1.4
I've been working with Cocoon for a week. I have a simple xml page to be run
through an SQLTransformer
====
<page xmlns:sql="http://apache.org/cocoon/SQL/2.0">
<title>SQLTransformer Test</title>
<content>
<para>
<execute-query xmlns="http://apache.org/cocoon/SQL/2.0">
<query>
select count(*) as total,
sum(XID) as IDSUM
from XMAN
</query>
</execute-query>
</para>
</content>
</page>
======
and this is what I get back (note that xmlns is declared twice in the
<rowset> element):
======
<?xml version="1.0" encoding="UTF-8"?>
<page xmlns:sql="http://apache.org/cocoon/SQL/2.0">
<title>SQLTransformer Test</title>
<content>
<para>
<rowset nrofrows="1" xmlns="http://apache.org/cocoon/SQL/2.0"
xmlns="http://apache.org/cocoon/SQL/2.0"><row><total>2</total><idsum>25</idsum></row></rowset>
</para>
</content>
</page>
=======
Is this a bug, or did I configure something incorrectly? I can get around
this by explicitly naming the namespace via <execute-query
xmlns:cocsqlt="http://apache.org/cocoon/SQL/2.0"> but that's annoying.
I-Lin Kuo, Ann Arbor, MI
Macromedia Certified ColdFusion 5.0 Advanced Developer
Sun Certified Java 2 Programmer
Ann Arbor Java Users Group (http://www.aajug.org)
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: SQLtransformer repeats namespace
Posted by Martin Holz <ho...@fiz-chemie.de>.
"I-Lin Kuo" <ik...@hotmail.com> writes:
> I've been working with Cocoon for a week. I have a simple xml page to
> be run through an SQLTransformer
>
> ====
> <page xmlns:sql="http://apache.org/cocoon/SQL/2.0">
> <title>SQLTransformer Test</title>
> <content>
> <para>
> <execute-query xmlns="http://apache.org/cocoon/SQL/2.0">
> <query>
> select count(*) as total,
> sum(XID) as IDSUM
> from XMAN
> </query>
> </execute-query>
> </para>
> </content>
> </page>
> ======
> and this is what I get back (note that xmlns is declared twice in the
> <rowset> element):
>
> ======
> <?xml version="1.0" encoding="UTF-8"?>
> <page xmlns:sql="http://apache.org/cocoon/SQL/2.0">
> <title>SQLTransformer Test</title>
> <content>
> <para>
> <rowset nrofrows="1" xmlns="http://apache.org/cocoon/SQL/2.0"
> xmlns="http://apache.org/cocoon/SQL/2.0"><row><total>2</total><idsum>25</idsum></row></rowset>
>
> </para>
> </content>
> </page>
> =======
> Is this a bug, or did I configure something incorrectly? I can get
> around this by explicitly naming the namespace via <execute-query
> xmlns:cocsqlt="http://apache.org/cocoon/SQL/2.0"> but that's annoying.
>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
RE: SQLtransformer repeats namespace
Posted by Luca Morandini <lu...@tin.it>.
I-Lin,
yes, there are a number of strange things about XML namespaces in SQL Transformer: one of those I ironed out myself... the others I
left to Carsten ;)
What I usually do is mention the namespace in the root element and then prefix all elements with the "sql" prefix.
I think it is clearer than implicit prefixes.
Regards,
---------------------------------------------
Luca Morandini
GIS Consultant
lmorandini@ieee.org
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
> -----Original Message-----
> From: I-Lin Kuo [mailto:ikuoikuo@hotmail.com]
> Sent: Wednesday, February 05, 2003 10:03 PM
> To: cocoon-users@xml.apache.org
> Subject: SQLtransformer repeats namespace
>
>
> Running Cocoon 2.04 on Tomcat 4 on Apache 2 on Windows XP with JDK 1.4
>
> I've been working with Cocoon for a week. I have a simple xml page to be run
> through an SQLTransformer
> ====
> <page xmlns:sql="http://apache.org/cocoon/SQL/2.0">
> <title>SQLTransformer Test</title>
> <content>
> <para>
> <execute-query xmlns="http://apache.org/cocoon/SQL/2.0">
> <query>
> select count(*) as total,
> sum(XID) as IDSUM
> from XMAN
> </query>
> </execute-query>
> </para>
> </content>
> </page>
> ======
> and this is what I get back (note that xmlns is declared twice in the
> <rowset> element):
> ======
> <?xml version="1.0" encoding="UTF-8"?>
> <page xmlns:sql="http://apache.org/cocoon/SQL/2.0">
> <title>SQLTransformer Test</title>
> <content>
> <para>
> <rowset nrofrows="1" xmlns="http://apache.org/cocoon/SQL/2.0"
> xmlns="http://apache.org/cocoon/SQL/2.0"><row><total>2</total><idsum>25</idsum></row></rowset>
> </para>
> </content>
> </page>
> =======
> Is this a bug, or did I configure something incorrectly? I can get around
> this by explicitly naming the namespace via <execute-query
> xmlns:cocsqlt="http://apache.org/cocoon/SQL/2.0"> but that's annoying.
>
> I-Lin Kuo, Ann Arbor, MI
> Macromedia Certified ColdFusion 5.0 Advanced Developer
> Sun Certified Java 2 Programmer
> Ann Arbor Java Users Group (http://www.aajug.org)
>
>
> _________________________________________________________________
> Tired of spam? Get advanced junk mail protection with MSN 8.
> http://join.msn.com/?page=features/junkmail
>
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>