ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brice Ruth <bdr...@gmail.com>
Subject Re: change in property value inside <select/>
Date Wed, 19 Jan 2005 16:21:43 GMT
Many diffierent solutions are presented here, personally - I use the
"CONCAT" string function which is present in most SQL databases, that
way you don't need to worry about how strings are concatenated in
short hand.

YMMV
Brice


On Tue, 18 Jan 2005 12:22:55 -0500, Nilesh Bhattad
<nilesh@outlinesys.com> wrote:
>  
>  
> 
> Hello, 
> 
>   
> 
> Is there a way to change a property value before it is plugged in to the
> select statement? 
> 
>   
> 
> <select id="search" parameterClass="java.util.HashMap"
> resultClass="java.util.HashMap"> 
> 
>           select ConsultantId, BlackListed, FirstName, LastName,
> HomeTelephone, EmailAddress, InterviewGrade, TotalYrsOfExp from Consultant 
> 
>             <dynamic prepend=" where "> 
> 
>                 <isNotEmpty property="FirstName" prepend=" and ">FirstName
> like #FirstName#</isNotEmpty> 
> 
>                 <isNotEmpty property="LastName" prepend=" and ">LastName
> like #LastName#</isNotEmpty> 
> 
>                 <isNotEmpty property="ActiveInactive" prepend=" and
> ">ActiveInactive like #ActiveInactive#</isNotEmpty> 
> 
>             </dynamic>    
> 
>           order by FirstName, LastName 
> 
>      </select> 
> 
>   
> 
> For example, in the above case, when FirstName is present, is there a way to
> attach '%' at the end of the FirstName's value and then perform the select
> operation? 
> 
>   
> 
> For some reason, in the calling program, I won't be able to attach '%' at
> the end of the search fields. Well, somehow I could achieve that before the
> iBatis call is made, but I'm kindof hesitant to go with that approach. So I
> was wondering is there any way to handle it in iBatis layer. Any help is
> highly appreciated. 
> 
>   
> 
> Thanks 
> 
> Nilesh

Mime
View raw message