pete depends what you mean by "at some different time"? one way would be to pre-process this file via an XSLT stylesheet - pass in a parameter corresponding to the SQL you want to run and extract just the <query> you need, and then pass the output through to the SQL transformer.
hth derek >>> [EMAIL PROTECTED] 2006/01/23 10:33 AM >>> Hello, I would like to to put multiple sql queries into the sql.xml file like this: <execute-query name="users" xmlns="http://apache.org/cocoon/SQL/2.0"; > <!-- Query this in step 1 --> <query name="users"> SELECT * FROM USERS </query> <!-- Query this in step n --> <query name="hobby"> SELECT * FROM Hobby </query> </execute-query> These 2 queries are not queried at the same step but each at some different time. Normally I would have to write them into separate files but I want to have them in the same document so I don't have have say twenty sql.xml documents containing each one sql statement. How can I do this? Cheers, Pete --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- 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]
