Query Regarding Sub Query - to pass more than one paramete.

[Shankhavara, Kashyap]

Hi,

 

Topic: I want to pass more than one parameter to the sub query.

 

Like,

<resultMap id="get-product-result" class="com.ibatis.example.Product">

<result property="id" column="PRD_ID"/>

<result property="description" column="PRD_DESCRIPTION"/>

<result property="category" column="PRD_CAT_ID" select="getCategory"/>

</resultMap>

 

In the getCategory query, I need to pass 2 parameters. Is it possible?

Could you please reply me ASAP (with example, if possible).

 

Thanks in anticipation.

 

Regards,

Kashyap