ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ingmar Lötzsch <iloetz...@asci-systemhaus.de>
Subject Re: Select Query 'LIKE' Issue
Date Thu, 15 Oct 2009 12:31:54 GMT
If || is the operator for string concatenation, try

like '$pattern$' || '%'

respectively

like '%' || '$pattern$' || '%'

gonas schrieb:
> Hello ,
> 
> I am using Ibatis 2.3.Issue Persist as Below mentioned.
> 
> Query in Respective Configuration XML As:
> 
> <select id="getSerialNumber" resultClass="java.lang.String">
>  	select ifnull(max(account_number),0) from account_details where
> account_number like '$pattern$%'
> </select>
> 
> TRIED PATTERS : $pattern$% , %$pattern$%
> So Here SQL always retuning Non Zero Value.If suppose In DB '99970' such
> data exist ,where i am trying to search for '99980' then also i am getting
> Non Zero Values.Ideally in this case DB Should return zero according to
> query.
> 
> If any one of you understand the scenario please notify me any thing wrong
> in this.
> CONFIGURATION :: OK.
> 
> Thanks in Advance,
> Suman


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message