You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Derek Hohls <dh...@csir.co.za> on 2004/07/01 19:10:01 UTC

Re: Multiple SQL Queries

Guy

There should be nothing preventing you 
having a series of queries in, say, a 
JXTemplate page, with suitable wrappers,
and then generating these and running these
through a SQLTransformer.

What have you tried that does not work?

Derek

>>> guy.picton-phillipps@brentpct.nhs.uk 06/30/04 6:35 PM >>>
Hello,
I am trying to configure a pipeline that will perform multiple queries
on
different tables in the same database and output the result to a single
XML
file, with the individual queries being differentiated by <query name =
"query 1">,  <query name = "query 2">....etc. 
In the SQL transformer literature, there is reference to performing a
sequence of queries and using a further transformer to process the
results.
I assume that I need to instantiate each query separately, but have not
had
any success with this so far. Can anyone give some insight into the
steps
necessary to achieve the above? 

Thanks,

Guy

 






**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

Kensington & Chelsea PCT
**********************************************************************


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org



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