Andrew Stevens wrote:
> What about
It works!
<sql:execute-query>
<sql:query>
SELECT ...
FROM ...
WHERE name = ?
</sql:query>
<sql:in-parameter nr="1" value="{$whatever}"/>
</sql:execute-query>
I had looked over this tiny bit of information in the docs [1]:
«You can also use the in-parameter in combination with a SQL statement.»
Looking at the SQL transformer javadoc, I see other things that could be
useful: <sql:escape-string>, <sql:xml>, <sql:use-connection>... which
are neither mentioned in [1] nor used in the samples. Looks like I'll
have to dig into the sources to truly understand this transformer.
> Admittedly, as written above you've got to supply the in-parameter
> to the XSL transformer rather than the SQL transformer
And that's precisely what I need.
Thank you.
Tobia
[1] http://cocoon.apache.org/2.1/userdocs/sql-transformer.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
