Re: mutiple parameters in query

[jesid]

I found the answer and it is this :clap:

List result = sqlMap.queryForList("twoTables", params);


and the xml

<resultMap id="paramTable" class="hashmap">
        <result property="cod" column="COD"/>
        <result property="default" column="DEF"/>
        <result property="codeCar" column="COD_CAR"/>
        <result property="name" column="NAME"/>
</resultMap>

<select id="twoTables" resultClass="hashmap" resultMap="paramTable">
        SELECT 
                *
        FROM 
                IPS_CARA car,
                IPS_PERSON per
        WHERE
                car.COD_CAR = per.COD_CAR and
                car.COD = #codeCar#
</select>


thus returns a list filled with hasMap containing all objects.

Good luck
-- 
View this message in context: 
http://www.nabble.com/mutiple-parameters-in-query-tp19098786p19108786.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.