I'm losing my faith in SQL Transformer. For a quite while now, I have been opening my Big Mouth everytime someone talks about running queries in XSP, because the SQL Transformer is more 'cocoon-like' in terms of the pipelines-and-components model.
I have been frustrated before by the fact that it only nests down to one level; its still not clear to me why further levels of nesting cannot be supported? That aside, I now find another source of frustration, this one more serious. What I am needing to do is intersperse XML tags amongst nested SQL queries. So as a SIMPLIFIED example: <Xxml version="1.0" encoding="UTF-8"?> <rpt:report xmlns:rpt="http://my.org/report"; xmlns:sql="http://apache.org/cocoon/SQL/2.0"; > <sql:execute-query> <rpt:cols> <sql:query> SELECT * FROM organisaion </sql:query> </rpt:cols> <rpt:matrix> <sql:execute-query> <sql:query> SELECT * FROM person WHERE OrgID = "<sql:ancestor-value sql:name="OrgID" sql:level="1"/>" </sql:query> </sql:execute-query> </rpt:matrix> </sql:execute-query> </rpt:report> Expecting this will return: <Xxml version="1.0" encoding="UTF-8" ?> <rpt:report xmlns:rpt="http://my.org/report"; xmlns:sql="http://apache.org/cocoon/SQL/2.0";> <sql:rowset> <rpt:cols> <sql:row> <sql:name>Derek</sql:name> </sql:row> </rpt:cols> <rpt:matrix> <sql:rowset nrofrows="0"/> </rpt:matrix> </sql:rowset> </rpt:report> But instead I get: <Xxml version="1.0" encoding="UTF-8" ?> <rpt:report xmlns:rpt="http://my.org/report"; xmlns:sql="http://apache.org/cocoon/SQL/2.0";> <rpt:cols /> <rpt:matrix /> <sql:rowset nrofrows="6"> <sql:row> <sql:name>Derek</sql:name> <sql:rowset nrofrows="0"/> </sql:row> </sql:rowset> </rpt:report> How do I set up the input file such that I can have the output structured properly (without writing another specialised XSLT file - this would defeat the whole purpose of using the template layout in the first place!)? Thanks Derek Derek Hohls Systems Developer Natural Resources and the Environment CSIR PO Box 17001 Kwa-Zulu Natal South Africa 4013 www.csir.co.za -- This message is subject to the CSIR's copyright, terms and conditions and e-mail legal notice. Views expressed herein do not necessarily represent the views of the CSIR. CSIR E-mail Legal Notice http://mail.csir.co.za/CSIR_eMail_Legal_Notice.html CSIR Copyright, Terms and Conditions http://mail.csir.co.za/CSIR_Copyright.html For electronic copies of the CSIR Copyright, Terms and Conditions and the CSIR Legal Notice send a blank message with REQUEST LEGAL in the subject line to [EMAIL PROTECTED] NOTE: The CSIR (http://www.csir.co.za/) has formally adopted the open document format (ODF) as the standard to support open access to information. More information on the ODF is available at http://opendocumentfellowship.org/ and the official web site of the non-profit organisation for the Advancement of Structured Information Standards (http://www.oasis-open.org/home/index.php). The latest copy of OpenOffice can be downloaded from http://www.openoffice.org/. Enquiries regarding the CSIR's move to open source software can be directed to [EMAIL PROTECTED] This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. MailScanner thanks Transtec Computers for their support. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
