Hi Martin,

This did not work:
<sql:query var="getLeaveRecord">
select * from emp_leaves where leave_id=<c:out value='${param["name"]}'/>
</sql:query>

This is the scenario:
String s1 = request.getParamter("name");

I want to pass s1 into a SQL query which is like this:

<sql:query var="getLeaveRecord">
select * from emp_leaves where leave_id=?
</sql:query>

thanks
-raj




                                                                                       
                    
                      "Martin van                                                      
                    
                      Dijken"                  To:       "Tag Libraries Users List"    
                    
                      <[EMAIL PROTECTED]         <[EMAIL PROTECTED]>                   
       
                      .nl>                     cc:                                     
                    
                                               Subject:  RE: Putting value ot a 
variable                   
                      10/09/2003 03:08                                                 
                    
                      PM                                                               
                    
                      Please respond to                                                
                    
                      "Tag Libraries                                                   
                    
                      Users List"                                                      
                    
                                                                                       
                    
                                                                                       
                    




Hey Rajendra,

Try:

<sql:query var="getLeaveRecord">
select * from emp_leaves where leave_id=<c:out value='${param["name"]}'/>
</sql:query>

Martin

> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: donderdag 9 oktober 2003 11:36
> To: Tag Libraries Users List
> Subject: Re: Putting value ot a variable
>
>
>
> Thanks Dima.
> I am stuck with another problem now.
>
> I have a variable in Java which i get from request.
> String s1 = request.getParamter("name");
>
> I want to pass s1 into a SQL query which is like this:
>
>
> How do i put s1 into the tags?
>
>
> thanks
> -raj
>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]








---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to