August 21st, 2000, 04:55 PM
|
|
Contributing User
|
|
Join Date: Dec 2002
Posts: 14,575
Time spent in forums: < 1 sec
Reputation Power: 22
|
|
|
ASP incorrectly displays SQL NUMERIC 6,3 field
<i><b>Originally posted by : Allan (aspielma@yahoo.com)</b></i><br />I am using a ASP recordset to access data from SYBASE SQL.<br /><br />There is a SYBASE SQL table with certain numeric fields defined as NUMERIC 6,3<br /><br />I use a stored procedure to retrieve certain rows and another one to update and insert rows. Certain numbers are appearing incorrectly when displayed by ASP, even though they are corect in the SQL table.<br /><br />Here are some examples:<br />SQL ASP<br />10 1.0<br />20 2.0<br />16 16.0<br />10.01 10.1<br /><br />Zeros are being dropped from the integer part of the number IF THERE IS NO NON ZERO DECIMAL DIGIT. <br />
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
