ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan Maves <Nathan.Ma...@Sun.COM>
Subject Re: Order By
Date Mon, 22 May 2006 20:21:46 GMT
use a map as the parameter

map.put("orderBy", orderBy");
map.put("businessObj", businessObj);

Then in the sqlmap...

<select id="getaTableByAll" resultMap="result"  
parameterClass="BusClass">

select * from aTable where col1 like #businessObj.col1# and col2 like  
#businessObj,col2# order by $orderBy$

</select>


On May 22, 2006, at 1:41 PM, James Johnson wrote:

>
> I have the following select statement:
> <select id="getaTableByAll" resultMap="result"  
> parameterClass="BusClass">
>
> select * from aTable where col1 like #col1# and col2 like #col2#  
> order by $orderBy$
>
> </select>
>
> However, I do not have (and do not want) orderBy as a data member  
> of class BusClass. How can I pass in orderBy without it being a  
> data member of class BusClass? Thanks for the help in advance.
>
>


Mime
View raw message