"XSL and Database Actions are deprecated" As far as I know, XSL is not deprecated - perhaps you meant XSP? But I am not sure that is deprecated... perhaps one of the developers could address the plans for that technology - will it still be supported in versions 2.2 and beyond?
>>> "warrell harries" <[EMAIL PROTECTED]> 06/18/07 9:46 AM >>> Hi, Does the database you are using support stored procedures (even MySql now does)? If so, write the complex SQL as a strored procedure and then execute the stored procedure from the SQLTransformer, possibly using the ancestor construct that the SQLTransformer has specifically to support nested Queries. Personally, I don't see a problem with doing some XSL transformation after one query before doing another based on the output DOM; this is what XML pipelines are all about. Perhaps you are not very familiar with XSL. Invest some time and you will be rewarded! XSL and Database Actions are deprecated so I would recommend the pipeline approach as you will end up with a more maintainable and extensible solution because you will seperate the concerns. Regards, Warrell > > -- 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] This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]