Return-Path: 
 <user-java-return-3224-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 1446 invoked from network); 11 Jul 2005 22:24:09 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 11 Jul 2005 22:24:09 -0000
Received: (qmail 36226 invoked by uid 500); 11 Jul 2005 22:24:07 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 36208 invoked by uid 500); 11 Jul 2005 22:24:06 -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 36194 invoked by uid 99); 11 Jul 2005 22:24:06 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Jul 2005 15:24:06 -0700
X-ASF-Spam-Status: No, hits=0.9 required=10.0
	tests=FROM_ENDS_IN_NUMS,FROM_HAS_ULINE_NUMS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [68.142.206.38] (HELO web32808.mail.mud.yahoo.com)
 (68.142.206.38)
    by apache.org (qpsmtpd/0.29) with SMTP; Mon, 11 Jul 2005 15:24:03 -0700
Received: (qmail 77951 invoked by uid 60001); 11 Jul 2005 22:23:59 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
  b=zZj6PSuZSsEbNqeilXWTKBSOOkbR7i9VbC431Em9RmpiQzPrmJ2bZQ8PRDa4L8uOJIOUdgYjiFuL/jvUEY0XlaguYjUyw811VgeHHDwmgjJlirCdkkovKFaSxkbn+KGBHorREgWdlmUzVRTUlS4lmC+OQ8ABnFoGGJzg7Dcni24=
  ;
Message-ID: <20050711222359.77949.qmail@web32808.mail.mud.yahoo.com>
Received: from [192.77.198.12] by web32808.mail.mud.yahoo.com via HTTP;
 Mon, 11 Jul 2005 15:23:59 PDT
Date: Mon, 11 Jul 2005 15:23:59 -0700 (PDT)
From: Ashish Kulkarni <kulkarni_ash1312@yahoo.com>
Subject: how to define multiple input parameters in select statement
To: user-java@ibatis.apache.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Hello
If my sql statement is "select * from abc where a = ?"
then i define in my xml file as below
<select id="getPOData" resultClass="DataBean"
		parameterClass="java.math.BigDecimal">
  SELECT * from abc where a = #value#>
</select>
In my java program i do
List list  = sqlMap.queryForList("getPOData",
bigDecimal);

Q1 If i have multiple parameters in select statement
how do i define, 
for example my sql statement will be 
select * from abc where a =? and b =? and c=?

Ashish


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com