>
>
> 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?
No, you can just do :
<page>
<sql:execute-query>
<sql:query name="somequery">
......
</sql:query>
</sql:execute-query>
<sql:execute-query>
<sql:query name="someotherquery">
......
</sql:query>
</sql:execute-query>
</page>
Now you have two independant queries
AS
>
> 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]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
