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