Order By

[James Johnson]

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.