ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From PraDz <pradheep.ayya...@appliedevelopment.com>
Subject Ibatis :: [usage of IN]
Date Fri, 13 Apr 2007 07:12:56 GMT

Dear all

i am using iBatis for the past 6 months and its really gud.

now i am using a query which will retrieve multiiple records.

i am using like this in the query xml
<statement id="getReportList" parameterClass="ReportVO"
resultMap="get_Report">

<![CDATA[

SELECT * FROM message where m_id IN(#m_id#) and m_type in (100,110) and
timestamp >=#startTime# and timestamp < #stopTime# order by m_id, timestamp;
]]>

</statement>

ex: m_id=1,2,3,4
but the resultset doesnt return records for different m_id. only it
retrieves data for the first m_id.

kindly let me know if i can use IN or is there any other way that i can use.

-- 
View this message in context: http://www.nabble.com/Ibatis-%3A%3A--usage-of-IN--tf3570116.html#a9974026
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message