ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From RenZenggang <renzengg...@gmail.com>
Subject dynamic conditions problem
Date Fri, 16 Sep 2005 02:10:21 GMT
Hi all, i hava a sqlMap :
 * <select id="queryEntCollectionQueue" 
resultMap="entCollectionQueue_resultMap" parameterClass="HashMap">
<![CDATA[
select 
t.collect_handledate as handledate, 
t.collect_batchno as batchno, 
t.collect_customerno as customerno, 
t.collect_handleno as handleno, 
t.collect_relatedjnlno as relatedjnlno, 
t.collect_companyid as companyid, 
t.collect_amount as amount, 
t.collect_mode as collectMode, 
t.collect_currency as currency, 
t.collect_acno as acno, t.collect_status as status, 
t.collect_direct as direct, 
t.collect_executetimestamp as executetimestamp, 
t.collect_cusrefno as cusrefno, 
t.collect_submittimestamp as submittimestamp, 
t.collect_usagetext as usagetext, 
t.collect_responsecode as responsecode, 
t.collect_authctrl as authctrl, 
t.collect_filialecompanyid as filialecompanyid, 
t.collect_filialeacno as filialeacno, 
t1.ac_name as CollectedAccountName,
t.collect_voucherno as voucherno, 
t.collect_id as id, 
t.collect_voucherorgid as voucherorgid,
t.collect_seqauth,
t.collect_checkflag,
t.collect_appendeddata
from bocsh_collection_jnl t,bocsh_companyac t1
where (t.collect_filialecompanyid = t1.company_id
and t.collect_filialeacno = t1.ac_no)
]]>
<include refid="dynamicQueryEntCollectionQueueConditions" />
</select>*

* <sql id="dynamicQueryEntCollectionQueueConditions">
<dynamic>
<isNotEmpty prepend="and" property="BatchNo">(t.collect_batchno = 
#BatchNo#)</isNotEmpty>
<isNotEmpty prepend="and" property="HandleNo">(t.collect_handleno = 
#HandleNo#)</isNotEmpty>
<isNotEmpty prepend="and" property="HandleNoList">
<iterate property="HandleNoList" open=" (t.collect_id in(" conjunction="," 
close="))">#HandleNoList[]#</iterate>
</isNotEmpty>
<isNotEmpty prepend="and" property="HandleDate">(t.collect_handledate = 
#HandleDate#)</isNotEmpty>*

* <isNotEmpty prepend="and" property="AccountNoList">
<iterate property="AccountNoList" open=" (t.collect_acno in(" 
conjunction="," close=")) ">#AccountNoList[]#</iterate>
</isNotEmpty>
<isNotEmpty prepend="and" property="AccountNo">(t.collect_acno = 
#AccountNo#)</isNotEmpty>*

* <isNotEmpty prepend="and" property="CompanyID">(t.collect_companyid = 
#CompanyID#)</isNotEmpty>
<isNotEmpty prepend="and" property="Currency">(t.collect_currency = 
#Currency#)</isNotEmpty>*

* <isNotEmpty prepend="and" property="CollectId">(t.collect_id = 
#CollectId#)</isNotEmpty>
<isNotEmpty prepend="and" property="CollectIdList">
<iterate property="CollectIdList" open=" (t.collect_id in(" conjunction="," 
close="))">#CollectIdList[]#</iterate>
</isNotEmpty>*

* <isNotEmpty prepend="and" property="Status">(t.collect_status = 
#Status#)</isNotEmpty>
<isNotEmpty property="StatusList">
<iterate property="StatusList" prepend="and" open="( t.collect_status in(" 
conjunction="," close="))">#StatusList[]#</iterate>
</isNotEmpty>*

* <isNotEmpty prepend="and" property="BeginDate">
<![CDATA[(t.collect_handledate >= #BeginDate#)]]>
</isNotEmpty>
<isNotEmpty prepend="and" property="EndDate">
<![CDATA[(t.collect_handledate <= #EndDate#)]]>
</isNotEmpty>*

* <isNotEmpty prepend="and" property="HandleDateList">
<iterate property="HandleDateList" open=" (t.collect_id in(" conjunction="," 
close="))">#HandleDateList[]#</iterate>
</isNotEmpty>*

* <isNotEmpty prepend="and" property="CollectMode">(t.collect_mode = 
#Mode#)</isNotEmpty>*
* <isNotEmpty prepend="and" property="CollectCompanyID">(
t.collect_filialecompanyid = #CollectCompanyID#)</isNotEmpty>
<isNotEmpty prepend="and"
property="CollectAccountNo">(t.collect_filialeacno=
#CollectAccountNo#)</isNotEmpty>
<isNotEmpty prepend="and" property="CollectDirect">(t.collect_direct = 
#CollectDirection#)</isNotEmpty>
</dynamic>
</sql>*
i call queryForOject(),the db error accured:"sql not properly ended!"
but after i added "(" and ")" for every sub dynamic clause,is ok!
the database is Ora8i.
why?
 -- 
RenZenggang
Renzenggang@gmail.com
MSN:rzg117@hotmail.com

Mime
View raw message