Guest_imported
New member
- Jan 1, 1970
- 0
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.
******************************************************************
<table width="100%" border="2" bordercolor="Gray" bordercolorlight="Gray" bordercolordark="Gray" datapagesize="12" bgcolor="#C6C6FF" id="tblDATA" datasrc="#ADC">
<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?
Cheers
Thumbesh
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.
******************************************************************
<table width="100%" border="2" bordercolor="Gray" bordercolorlight="Gray" bordercolordark="Gray" datapagesize="12" bgcolor="#C6C6FF" id="tblDATA" datasrc="#ADC">
<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?
Cheers
Thumbesh