HEY!! i found a solution to this problem. what i did was send my results to a temp table that i created with an identity collumn. In sybase this would auto matically add an unique number to the row. then returned a select from teh temp table. i then mapped my id to the newly created identity collumn and it worked great. heres the code....
I started my stored procedure with this:
Create Table #tmp (
dummyId numeric(5,0) identity,
TradingEntityId Char(10) Null,
PartyA_Abbrev Char(5) Null,
Negotiator Char(60) Null,
)
then a bunch of SP code that put its results in teh temp table
and finished my stored procedure with this
Select
dummyId,
TradingEntityId,
PartyA_Abbrev,
Negotiator
From
#tmp
my mapping file looked like this:
<class name="MasterData" mutable="false">
<id name="dummyId"/>
<property name="tradingEntityId"/>
<property name="partyA_Abbrev"/>
<property name="negotiator"/>
</class>
<sql-query name="pr_EMAF_Acct_Search_SP" callable="true">
<return alias="myMasterData" class="MasterData">
<return-property name="dummyId" column="dummyId"/>
<return-property name="tradingEntityId" column="TradingEntityId"/>
<return-property name="partyA_Abbrev" column="PartyA_Abbrev"/>
<return-property name="negotiator" column="Negotiator"/>
</return>
{ call pr_EMAF_Acct_Search_test(:srchId,:srchName) }
</sql-query>
hope this helps you. it worked for me.
Login
FAQ
Search