Hi Luca - I agree that the SPs are the way to go - when I was a DBA, I used to enforce their use all the time. What I was after here was to include sitemap/request/session parameters into the XML file during the generation phase, so that the complete query would be passed to the transformer. I have gone the XSL route before, and I guess that is what I'll stick with now.
Thanks, Lajos Luca Morandini wrote: > 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]> > > -- 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]>