Can you not use
isParameterPresent prepend=AND
R.ORD_ID = O.ORD_ID
/isParameterPresent
Steve...
-Original Message-orderIdList
From: Rao, Satish [mailto:[EMAIL PROTECTED]
Sent: Thu 7/14/2005 4:23 PM
To: user-java@ibatis.apache.org
Subject: Using WHERE IN along with AND
I
Title: Using WHERE IN along with AND
I have the following select and it throws a UncategorizedSQL exception
select id=listDetailsForOrderIds parameterClass=java.util.List resultMap=list-rundetail-result
SELECT
R.ORD_ID AS ORD_ID,
PART_ID,
CLNT_ID_N,
PLAN_N