Return-Path: 
 <user-java-return-3169-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 54799 invoked from network); 7 Jul 2005 20:10:37 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 7 Jul 2005 20:10:37 -0000
Received: (qmail 13206 invoked by uid 500); 7 Jul 2005 20:10:35 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 13191 invoked by uid 500); 7 Jul 2005 20:10:34 -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 13178 invoked by uid 99); 7 Jul 2005 20:10:34 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Jul 2005 13:10:34 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [192.223.198.27] (HELO maillnx-us112.fmr.com) (192.223.198.27)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Jul 2005 13:10:34 -0700
Received: from MSGMMKSM02WIN.DMN1.FMR.COM (msgmmksm02win.dmn1.fmr.com
 [10.33.139.33])
	by maillnx-us112.fmr.com (Switch-3.1.2/Switch-3.1.0) with SMTP id
 j67KAVJx023383
	for <user-java@ibatis.apache.org>; Thu, 7 Jul 2005 16:10:32 -0400
Received: from MSGMMKIV02WIN.DMN1.FMR.COM (10.33.148.31)
	by MSGMMKSM02WIN.DMN1.FMR.COM (Sigaba Gateway v3.83)
	with ESMTP id 36009647; Thu, 07 Jul 2005 16:10:31 -0400
Received: from MSGMROIM01WIN.DMN1.FMR.COM ([172.26.2.194]) by
 MSGMMKIV02WIN.DMN1.FMR.COM with SMTP_server; Thu, 07 Jul 2005 16:10:31 -0400
Received: from MSGMMKCLB2WIN.dmn1.fmr.com ([172.25.107.167]) by
 MSGMROIM01WIN.DMN1.FMR.COM with Microsoft SMTPSVC(5.0.2195.6713);
	 Thu, 7 Jul 2005 16:10:31 -0400
X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Using <iterate>
Date: Thu, 7 Jul 2005 16:10:31 -0400
Message-ID: 
 <2352A440BDEB4E45A8E96E277F2376570152236D@MSGMMKCLB2WIN.DMN1.FMR.COM>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Using <iterate>
Thread-Index: AcWDL1GIW9MuFwb9SpefbGF5oFkuxAAAJJLg
From: "Rao, Satish" <satish.rao@fmr.com>
To: <user-java@ibatis.apache.org>
X-OriginalArrivalTime: 07 Jul 2005 20:10:31.0748 (UTC)
 FILETIME=[ED46F840:01C5832F]
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

That worked.. Thanks

-----Original Message-----
From: Brandon Goodin [mailto:brandon.goodin@gmail.com]=20
Sent: Thursday, July 07, 2005 4:06 PM
To: user-java@ibatis.apache.org
Subject: Re: Using <iterate>


Try....

<select id=3D"listRunDetailsForOrderIds" =
parameterClass=3D"java.util.List"
resultMap=3D"list-rundetail-result">
                SELECT
                        SSN_N,
                        FST_NM,
                        LST_NM,
                        CHANNEL_TYPE
                FROM
                        ORDER
                WHERE
                <iterate conjunction=3D"OR">
                        SSN_N =3D #orderIdList[]#
                </iterate>
        </select>

On 7/7/05, Rao, Satish <satish.rao@fmr.com> wrote:
> =20
>=20
> I have the following <select> and it throws a
UncategorizedSQLException. Is
> there anything wrong with the syntax?=20
> =20
>=20
>         <select id=3D"listRunDetailsForOrderIds"
> parameterClass=3D"java.util.List"
> resultMap=3D"list-rundetail-result">=20
>                 SELECT=20
>                         SSN_N,=20
>                         FST_NM,=20
>                         LST_NM,=20
>                         CHANNEL_TYPE=20
>                 FROM=20
>                         ORDER=20
>                 WHERE=20
>                 <iterate property=3D"orderIdList" conjunction=3D"OR">=20
>                         SSN_N =3D #orderIdList[]#=20
>                 </iterate>=20
>         </select>=20
>=20
> Here's the java call...=20
>=20
>         List runDetailList =3D
>
super.getSqlMapClientTemplate().queryForList("listRunDetailsForOrderIds"
,
> orderIdList);=20
>=20
> orderIdList is a java.util.List and contains a bunch of String
objects.=20
> =20
> =20
>