cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Luca Morandini" <luca.morandi...@tin.it>
Subject RE: Getting parameters to SQLTransformer
Date Mon, 24 Jun 2002 20:41:28 GMT
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
              lmorandini@ieee.org
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------


> -----Original Message-----
> From: Lajos Moczar [mailto:lmocz@galatea.com]
> Sent: Monday, June 24, 2002 10:18 PM
> To: cocoon-users@xml.apache.org
> 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:     <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>
>


---------------------------------------------------------------------
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message