Thanks but not sure I can use this. I have a logicsheet/xsl which abstracts the sql for each query. Therefore the db stores the queries as xml otherwise the sql would exist in 2 places (possible maintenance issues with that). The first query retrieves the abstracted XML queries tags from the db. I then need to apply the xsl which inserts the sql for that XML and then run those queries.
-----Original Message----- From: Nicola Ken Barozzi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 8:12 AM To: [EMAIL PROTECTED] Subject: Re: [C2]Caching of dynamic pipeline input ----- Original Message ----- From: "Miller, Grant" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 21, 2002 7:03 PM Subject: [C2]Caching of dynamic pipeline input > I cannot use esql because the results of the queries are themselves queries > ( I query the DB to find out what queries are needed for the requested > page); as esql can only be used in a generate step it can presumably only be > used once per request. ESQL handles nested queries. Look in the Cocoon example file process-department.xsp for a hint. -- Nicola Ken Barozzi [EMAIL PROTECTED] These are the days of miracle and wonder... ...so don't cry baby, don't cry... Paul Simon --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]> This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you. --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>