cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Derek Hohls" <dho...@csir.co.za>
Subject I'm losing my faith in SQL Transformer!
Date Fri, 24 Aug 2007 15:30:45 GMT
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
CallCentre@csir.co.za.

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 vula@csir.co.za


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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message