Number Fields with ceros to the right truncated
Posted on 2003-10-28
I'm working with ASP, ADO and Sybase via ODBC. I'm having troubles with numeric fields in my tables, the first and most critic is that every time I get a numeric value from my recordset the ceros are truncated. For exmaple, If I have 8,80,800, 800.00 all the values are passed as 8!! Here is an example of my code:
Set conn = Server.CreateObject("ADODB.Connection")
set rectel = Server.CreateObject("ADODB.Recordset")
strsql="SELECT telephony.price" _
& " FROM telephony.dbo.call_type call_type"
rectel.Open strsql, conn
and when I try:
The resul is truncated.
furthermore if I try any kind of mathematical operation I have alway to use Cdbl(rectel.Fields("price")) or it wont work.
And also in the operation the value is truncated!!!
Is there any configuration or something to avoid this (I already validated the regional settings in the server and the are right)?? and how can I check for the data type of the fields the recordset is giving me??
Thanks in advance!!