Vadim,
And so I plug in:
map:generate type=serverpages
src=FileWithCIncludedXspRightNow.xsp
map:parameter name=GeneratedSQL
value=cocoon:/generatedSQL.sql/
/map:generate
But all I get on the console is:
param is: cocoon:/generatedSQL.sql
Yes sure, what you put
I need some advice.
I have an xsp which is using esql. The query in the esql is dynamically
generated (based upon the request string). I use cinclude to inject the
dynamic sql into the esql element. Something like this:
esql:execute-query
esql:query
cinclude:include
From: Stephen Ng [mailto:[EMAIL PROTECTED]]
I need some advice.
I have an xsp which is using esql. The query in the esql is
dynamically
generated (based upon the request string). I use cinclude to inject
the
dynamic sql into the esql element. Something like this:
esql:execute-query
Why not generate SQL string *in* this XSP? That's would give
the best performance.
Or, other way is to obtain this SQL string into String
programmatically, without using include.
Okay I understand the suggestion but it doesn't work that well in my
case. The reason is that the sql
From: Stephen Ng [mailto:[EMAIL PROTECTED]]
Why not generate SQL string *in* this XSP? That's would give
the best performance.
Or, other way is to obtain this SQL string into String
programmatically, without using include.
Here I mean do not use include to include your XSLT
Vadim,
Here I mean do not use include to include your XSLT generated
SQL, but access cocoon programmatically and get this SQL into
String. Then, you will have static XSP source.
Sounds good to me but I have absolutely no idea how to do this :-(. Can
you give me a pointer?
Have you
Stephen,
Maybe the SQL-Transformer can help you.
Reinhard
-Original Message-
From: Stephen Ng [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 8:55 PM
To: Vadim Gritsenko; [EMAIL PROTECTED]
Subject: RE: Dynamic sql in xsp
Why not generate SQL string
Maybe the SQL-Transformer can help you.
Reinhard
No doubt I should move to this eventually (I was just getting to like
esql!)--as I understand it this would clearly eliminate the java
compilation step since there is no xsp involved. Nevertheless I think
short term I should be able to get a
From: Stephen Ng [mailto:[EMAIL PROTECTED]]
Vadim,
Here I mean do not use include to include your XSLT generated
SQL, but access cocoon programmatically and get this SQL into
String. Then, you will have static XSP source.
Sounds good to me but I have absolutely no idea how to do