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
              [EMAIL PROTECTED]
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------


> -----Original Message-----
> From: I-Lin Kuo [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 05, 2003 10:03 PM
> To: [EMAIL PROTECTED]
> 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:     <[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]>

Reply via email to