Re: help me in getting the meaning of oracle or jsp statemnt

Hi Kasi,

The + sign would be JSP, it is a concatenation. Based on the value of ecode, it completes the SQL-statement. the value of ecode is concatenated after the single quote, another single quote behind the value of ecode.

Suppose the value of ecode is 'Smith', the query would be: "select name from emp where ecode='Smith'". The query is then parsed and executed in Oracle (I suppose).

regards,

Henk Hultink

--
H. Hultink
Software Engineer
Stoas, Division OBOI
Wageningen, The Netherlands
"Activating Knowledge"
http://www.stoas.nl

e-mail: hhu_at_stopspam.stoas.nl

"kasi" <kaasiein_at_yahoo.co.in> wrote in message
news:f5309842.0303250008.47c94db_at_posting.google.com...


> hi everyone,

> i'm working with a jsp code which uses oracle as backend i come across

>  a statement like this

>

> rs2=st2.executeQuery("select name from emp where ecode='"+ecode+"'");

>

> what the + mean in --"+ecode+"

> is it related to jsp or oracle,

> help me in bebuging the code

> buy

> kasi