Vadim,
>> And so I plug in:
>>
>> > src="FileWithCIncludedXspRightNow.xsp">
>> > value="cocoon:/generatedSQL.sql"/>
>>
>>
>> But all I get on the console is:
>>
>> param is: cocoon:/generatedSQL.sql
>
> Yes sure, what you put there is what you get.
>
> And no, (answering yo
> 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 id
> 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
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
>
>
> >
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
> 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 you
>
> 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
> 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:
>
>
>
>