This seems to work.

Thanks

----- Original Message -----
From: "Antonio Gallardo Rivera" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 14, 2002 8:56 AM
Subject: Re: Escape characters in ESQL


> Try single quote example:
>
> <esql:execute-query>
>    <esql:query>
>       alter session set nls_date_format='DD/MM/YYYY'
>    </esql:query>
>  </esql:execute-query>
>
> Antonio Gallardo
>
> El Domingo, 13 de Octubre de 2002 23:45, Katzigas Dimitris escribi�:
> > Hi there,
> >
> > I want to execute this query over an Oracle database.
> >
> > alter session set nls_date_format="DD/MM/YYYY"
> >
> > the code fragment from my XSP file is shown below.
> >
> > <esql:execute-query>
> >   <esql:query>
> >      alter session set nls_date_format="DD/MM/YYYY"
> >   </esql:query>
> > </esql:execute-query>
> >
> > This of course doesn't work because i have to escape the double quotes
and
> > maybe the slashes, i don't know.
> > Even if i use the &quot; instead of the " it doesn't work either.
> >
> > Does anyone has any ideas on this?
> >
> > Thank you in advance
> >
> >
> > ---------------------------------------------------------------------
> > 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]>


---------------------------------------------------------------------
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]>

Reply via email to