Did you try Dima's solution as well? As I mentioned it is slightly better.

Martin

> -----Original Message-----
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED]
> Sent: vrijdag 10 oktober 2003 7:39
> To: Tag Libraries Users List
> Subject: RE: Putting value ot a variable
> 
> 
> 
> 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]
> 
> 

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

Reply via email to