Re: Order By

[Nathan Maves]

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.