Wouldn't

         parameterClass="BusClass"

in the <select> need to change to

         parameterClass="map"?

Ted

On 22/05/06, Nathan Maves <[EMAIL PROTECTED]> wrote:

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.


Reply via email to