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.