Hi, this is what I wanted to say with "at some different time". The queries are not related to each other. They will be called independently. :o/ So there is only the xslt approach?
Cheers, Pete -----Ursprüngliche Nachricht----- Von: Ard Schrijvers [mailto:[EMAIL PROTECTED] Gesendet: Montag, 23. Januar 2006 10:10 An: [email protected] Betreff: RE: SQLTransf. How to arrange multiple queries? You can do just multipe sql:execute-query. If the second is depending on the first one, you can use <sql:ancestor-value> Below an example of 2 main sql:execute-query where the first one has some child queries depending on the previous one <sql:execute-query> <sql:query name="max_poll"> select MAX(p.id) as id from polls as p where p.active = 1 group by p.active; </sql:query> <sql:execute-query> <sql:query name="poll"> select p2.id, p2.question, p2.description, p2.active from polls as p2 where p2.id = <sql:ancestor- value sql:level="1" sql:name="id"/>; </sql:query> <sql:execute-query> <sql:query name="choices"> select id,answer,votes from pollresult where poll_id = <sql:ancestor-value sql:level="2" sql:name="id"/>; </sql:query> </sql:execute-query> </sql:execute-query> </sql:execute-query> <sql:execute-query> <sql:query name="max_poll2"> select MAX(p.id) as id from polls as p where p.active = 1 group by p.active; </sql:query> <sql:execute-query> <sql:query name="voted_polls"> select voted_polls.id AS idvoted from voted_polls where voted_polls.poll_id = <sql:ancestor-value sql:level="1" sql:name="id"/> and voted_polls.employee_id = <sql:substitute-value sql:name="currentUserId"/>; </sql:query> </sql:execute-query> </sql:execute-query> AS > > > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
