Lajos,
the substitution in SQL Transformer uses parameters defined in the sitemap,
which don't fit your bill I presume...
...but, being it a transformer, you can feed it any SQL you have built from
whatever source (XSL, XSP, plain XML file, ...), including any parameters of
your choice.
This is not the same as "dynamic parameters" though, it is like "dynamic
SQL".
What I would suggest is the use of stored procedures, with an XSL building
the statement, hence:
1) max flexibility in the value of parameters (build them as you like, from
whatever source you like)
2) min performance penalty (the real SQLs are already been parsed when the
stored procedure was submitted to the DBMS)
Not to mention the SoC it enforces.
And if your DBMS doesn't support SPs ? Use dynamic SQL by using stylesheets
or XSPs: after all, this is what a lot of people does with ASP anyway.
Hope this helps,
---------------------------------------------
Luca Morandini
GIS Consultant
[EMAIL PROTECTED]
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
> -----Original Message-----
> From: Lajos Moczar [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 24, 2002 10:18 PM
> To: [EMAIL PROTECTED]
> Subject: Getting parameters to SQLTransformer
>
>
> I think I know the answer, but is there any way to construct dynamic
> queries using SQLTransformer? Specifically, I'd like to build the where
> clause of my query using either a session attribute or a sitemap
> parameter. I've been thru the code and don't see that it can be done,
> but I thought I'd ask just the same ... I'm on 2.0.2.
>
> Regards,
>
> Lajos
>
> --
> galatea.com
> Cocoon training, consulting & support
>
>
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
