Return-Path: 
 <user-java-return-17926-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 62384 invoked from network); 15 Oct 2009 10:34:36 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 15 Oct 2009 10:34:36 -0000
Received: (qmail 55454 invoked by uid 500); 15 Oct 2009 10:34:35 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 55426 invoked by uid 500); 15 Oct 2009 10:34:35 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 55418 invoked by uid 99); 15 Oct 2009 10:34:35 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 15 Oct 2009 10:34:35 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 15 Oct 2009 10:34:26 +0000
Received: from isper.nabble.com ([192.168.236.156])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <lists@nabble.com>)
	id 1MyNen-0000o2-V5
	for user-java@ibatis.apache.org; Thu, 15 Oct 2009 03:34:05 -0700
Message-ID: <25906258.post@talk.nabble.com>
Date: Thu, 15 Oct 2009 03:34:05 -0700 (PDT)
From: gonas <gona.suman@gmail.com>
To: user-java@ibatis.apache.org
Subject: Select Query 'LIKE' Issue
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: gona.suman@gmail.com
X-Virus-Checked: Checked by ClamAV on apache.org


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
-- 
View this message in context: http://www.nabble.com/Select-Query-%27LIKE%27-Issue-tp25906258p25906258.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


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