Return-Path: 
 <user-java-return-3226-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 5500 invoked from network); 11 Jul 2005 22:36:50 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 11 Jul 2005 22:36:50 -0000
Received: (qmail 51043 invoked by uid 500); 11 Jul 2005 22:36:48 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 51020 invoked by uid 500); 11 Jul 2005 22:36:48 -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 51002 invoked by uid 99); 11 Jul 2005 22:36:48 -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:36:48 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of larry.meadors@gmail.com
 designates 64.233.162.202 as permitted sender)
Received: from [64.233.162.202] (HELO zproxy.gmail.com) (64.233.162.202)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Jul 2005 15:36:45 -0700
Received: by zproxy.gmail.com with SMTP id s1so453450nze
        for <user-java@ibatis.apache.org>;
 Mon, 11 Jul 2005 15:36:45 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=Q1UyUxD5vlli73dSjTcrwduKEiMhotqytvXyASo51EdQ2/qiKY7u7zYU6JgaZaPBJmlrPzoy8smDGQLtt+/maQM32ctqwTuhjvpwEragV4FAA46nF+jopubRysNHOtOtPJ8YWvDfPAlxTezCN2jAn0v7UEaPDQ1BNLB9TyzNv98=
Received: by 10.36.103.20 with SMTP id a20mr1139208nzc;
        Mon, 11 Jul 2005 15:36:45 -0700 (PDT)
Received: by 10.36.90.14 with HTTP; Mon, 11 Jul 2005 15:36:45 -0700 (PDT)
Message-ID: <a10a823c0507111536527cae09@mail.gmail.com>
Date: Mon, 11 Jul 2005 16:36:45 -0600
From: Larry Meadors <larry.meadors@gmail.com>
Reply-To: lmeadors@apache.org
To: user-java@ibatis.apache.org
Subject: Re: how to define multiple input parameters in select statement
In-Reply-To: <20050711222359.77949.qmail@web32808.mail.mud.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <20050711222359.77949.qmail@web32808.mail.mud.yahoo.com>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Start by glancing at the docs, then come back if you still have questions.

Larry

On 7/11/05, Ashish Kulkarni <kulkarni_ash1312@yahoo.com> wrote:
> Hello
> If my sql statement is "select * from abc where a =3D ?"
> then i define in my xml file as below
> <select id=3D"getPOData" resultClass=3D"DataBean"
>                 parameterClass=3D"java.math.BigDecimal">
>   SELECT * from abc where a =3D #value#>
> </select>
> In my java program i do
> List list  =3D sqlMap.queryForList("getPOData",
> bigDecimal);
>=20
> 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 =3D? and b =3D? and c=3D?
>=20
> Ashish
>=20
>=20
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>