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.
