esql dynamic sql

[Oskar Werewka <ow...@poczta.onet.pl>]

I need to include in my sql statement
some parameters from request object
and also from my java code.

Example:

"select * from users where userid = <requerst:get-paramtere/>"

How about PreparedStatement?

"select * from users where userid = ?"

Can I use it somehow?

Thank again for your help.
Oskar Werewka.



-- 

Kamera wideo Sony, 5000 zl
wygraj w konkursie eMarketu i Onet.pl [ http://konkursy.onet.pl/emarket ]


---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>

Re: esql dynamic sql

[Donald Ball <ba...@webslingerZ.com>]

On Fri, 1 Jun 2001, Oskar Werewka wrote:

>
> I need to include in my sql statement
> some parameters from request object
> and also from my java code.
>
> Example:
>
> "select * from users where userid = <requerst:get-paramtere/>"
>
> How about PreparedStatement?
>
> "select * from users where userid = ?"
>
> Can I use it somehow?

yes.

<esql:query>select * from users where userid =
  <esql:parameter><request:get-parameter name="username"/></esql:parameter>
</esql:query>

it's seamlessly turned into a preparedstatement.

- donald



---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>