Posted by James Liang on
URL: https://discuss.orbeon.com/passing-a-pre-constructed-query-into-a-sql-processor-tp3559329.html

Hi,


I have to run a set of sql queries where the select clause is
identical but everything after the from clause are different.

The difference is more than just a matter of query parameters values.
For example, some times I need to use a sub query, some time with
different order by clause, and etc.

Is there a way to pass a pre-constructed sql statement into the sql processor?

For example, something like the following:

<sql:query>
  <sq:get-query select="/query">
</sql:query>

Here the <sql:get-query> will get the sql query string from input data.


Thanks,
James


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws