RDO problem (using MSDFMAP.handler)

[Guest_imported]

Hello,

I have a strange problem using Money data types in my ASP page.

I am using a RDO Control to display data returned from a stored procedure.

One of the fields is of money data type. But the data never gets retrieved.
If I convert it to float (in the stored proc) and then return, everything works fine.

I am not sure, but I think that RDO does not support Money data types.
I have the latest version of MDAC installed on my PC.


Anyone having any clues???


I am not able to call the FormatCurrency VB function because of the way the data is being displayed.
Below is the code to display the table.
Note: #ADC is the handle to the RDO object.


*****************************************************************
<!-- RDS.Data Control -->

<OBJECT classid=&quot;clsid:BD96C556-65A3-11D0-983A-00C04FC29E33&quot;
ID=&quot;ADC&quot; HEIGHT=0 WIDTH=0 ONDATASETCOMPLETE=&quot;displaybuttons()&quot;>
<PARAM NAME=&quot;Handler&quot; VALUE=&quot;MSDFMAP.Handler&quot;>
<PARAM NAME=&quot;Connect&quot; VALUE=&quot;data source=DB1&quot;>
<PARAM NAME=&quot;Server&quot; VALUE=&quot;

http://abc123&quot;>

<PARAM NAME=&quot;SQL&quot; VALUE=&quot;GetRecords('Loan','Z', 0)&quot;>
</OBJECT>

<!-- Display table headers-->
.
.

<!-- Displaying data -->
<table width=&quot;100%&quot; border=&quot;2&quot; bordercolor=&quot;Gray&quot; bordercolorlight=&quot;Gray&quot; bordercolordark=&quot;Gray&quot; datapagesize=&quot;12&quot; bgcolor=&quot;#C6C6FF&quot; id=&quot;tblDATA&quot; datasrc=&quot;#ADC&quot;>
<TR>
<TD width=25% align=left><SPAN DATAFLD=ShortName></SPAN></td>
<TD width=15% align=center><SPAN DATAFLD=DC></SPAN></td>
<TD width=20% align=right><SPAN DATAFLD=CurrComm></SPAN></td>
<TD width=20% align=right><SPAN DATAFLD=Outstanding></SPAN></td>
<TD width=20% align=right><SPAN DATAFLD=Available ></SPAN></td>
</TR>
</table>


**************************************************************


As you can see, I am not able to call the VBScript function here. Any other way of displaying data -so that i can call the formatcurreny function?


Cheers
Thumbesh