Return-Path: 
 <user-java-return-13492-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 49549 invoked from network); 22 Jan 2008 15:54:32 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 22 Jan 2008 15:54:32 -0000
Received: (qmail 46706 invoked by uid 500); 22 Jan 2008 15:54:20 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 46693 invoked by uid 500); 22 Jan 2008 15:54:20 -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 46682 invoked by uid 99); 22 Jan 2008 15:54:20 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Jan 2008 07:54:20 -0800
X-ASF-Spam-Status: No, hits=2.6 required=10.0
	tests=DNS_FROM_OPENWHOIS,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG
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; Tue, 22 Jan 2008 15:54:06 +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 1JHLRm-0000jr-UW
	for user-java@ibatis.apache.org; Tue, 22 Jan 2008 07:53:58 -0800
Message-ID: <15021710.post@talk.nabble.com>
Date: Tue, 22 Jan 2008 07:53:58 -0800 (PST)
From: xianwinwin <xianwinwin@gmail.com>
To: user-java@ibatis.apache.org
Subject: Re: howto pass a Long argument to a query (isNotNull)
In-Reply-To: <c593b8750801181000w6f09801clba1d9c8a429ab696@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: xianwinwin@gmail.com
References: <14954009.post@talk.nabble.com>
 <c593b8750801181000w6f09801clba1d9c8a429ab696@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org


Thank you Jeff - this solved my question!


Tou could do this:

<select id="secuser.select_user_group" parameterClass="java.lang.Long"
resultMap="SecUser_group">
           // query here
               <isParameterPresent prepend="AND">
                       SU.userId=#value#
               </isParameterPresent>
  </select>

Jeff Butler

-- 
View this message in context: http://www.nabble.com/howto-pass-a-Long-argument-to-a-query-%28isNotNull%29-tp14954009p15021710.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.