Java Mailing List Archive

http://www.java2.5341.com/

Home » user-java.ibatis »

Select Query 'LIKE' Issue

suman gona

2009-10-15

Replies: Find Java Web Hosting

Author LoginPost Reply

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
--
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@(protected)
For additional commands, e-mail: user-java-help@(protected)

©2008 java2.5341.com - Jax Systems, LLC, U.S.A.