hi,
I need to know if I can send IList<string> into the query as parameter and
get back an IList<string> as a result of a select statement.
The select query is as follows:
c# code: IList<string> stringDataList -->Input parameter
<select id="GetStringData" parameterClass="string"
resultMap="GetStringData-Result">
SELECT Col1 FROM tbl1
WHERE Col1 IN
<iterate property="stringDataList" open="(" close=")"
conjunction="," >
#stringDataList[]#
</iterate>
</select>
The resultmap statement is as follows:
<resultMap id="GetStringData-Result" class="string">
<result column="Col1" nullValue="" />
</resultMap>
Can anybody please guide me on how to write the resultmap statement. I don't
think the above is correct.
-----------------------------------------------------------------------
One more thing,
if I use a HashTable instead of IList<string> as output parameter how should
I write the resultmap
Thanks,
Regards,
vinay
--
View this message in context:
http://www.nabble.com/resultmap-inthe-form-of-IList%3Cstring%3E-tp18083929p18083929.html
Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.
