Parameter class in sql queries

[Manu Juyal <ma...@gmail.com>]

Hi,

Can we use more more than 1 class as parameter class.
e.g.
<select id="xxx" parameterclass = "class1, class2, class3", resultmap="ddd">

Is it the correct way of doing it?

Thanks.

RE: Parameter class in sql queries

["Nicholas L. Piasecki" <ni...@piasecki.name>]

Hi,

 

Try parameterClass="map" and use a Hashtable or a Dictionary, e.g.

 

Dictionary<string, object> map = new Dictionary<string,object>();

map.Add("User", user);

map.Add("Order", order);

 

LocalSqlMap.QueryForList<Whatever>("xxx", map);

 

..

 

<select id="xxx" parameterClass="map" resultMap="whatever">

                SELECT * FROM foo AS f

                WHERE f.User = #User.Name#

                AND f.OrderNumber = #Order.Number#

</select>

 

V/R,

Nicholas Piasecki

 

From: Manu Juyal [mailto:manudotnet@gmail.com] 
Sent: Friday, November 16, 2007 5:26 PM
To: user-cs@ibatis.apache.org
Subject: Parameter class in sql queries

 

Hi,

Can we use more more than 1 class as parameter class.
e.g.
<select id="xxx" parameterclass = "class1, class2, class3", resultmap="ddd">

Is it the correct way of doing it?

Thanks.