Eka Gautama wrote:
HI guys,
I am having problem currently. I have a very simple query with ORDER BY clause,
but I want to give parameter to what I am going to order. The parameter is
comes from the UI.
Here is the SQL MAP :
<select id="QueryBranch" resultClass="HashTable" parameterClass="HashTable">
SELECT BRANCH_CODE
,OFFICE_CODE
FROM BRANCH_MASTER
ORDER BY #SortExpr# ASC
</select>
#SortExpr# will be either BRANCH_CODE or OFFICE_CODE which is supplied from UI.
The above statements give me result but not in order that I want.
But, if I change into like this :
<select id="QueryBranch" resultClass="HashTable" parameterClass="HashTable">
SELECT BRANCH_CODE
,OFFICE_CODE
FROM BRANCH_MASTER
ORDER BY OFFICE_CODE ASC
</select>
It gives me the correct order of the records.
try something like
<dynamic prepend="ORDER BY ">
<isNotEmpty property="SortField">
$SortField$ $SortDirection$
</isNotEmpty>
</dynamic>
--
Kind regards
Uwe
Lesta at SBS-Softwaresysteme.de
