Re: Why do I lose precision when I write the results of a sql query to an
--0__=09BBE4EFDFE213388f9e8a93df938690918c09BBE4EFDFE21338
Content-type: multipart/alternative;
Boundary="1__=09BBE4EFDFE213388f9e8a93df938690918c09BBE4EFDFE21338"
--1__=09BBE4EFDFE213388f9e8a93df938690918c09BBE4EFDFE21338
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
I am guessing you are using the IBM Informix Ole DB provider to connect=
to
7.31
The problem seems similar to the one that was reported sometime last ye=
ar.
The Ole DB 2.81.TC3 provider (shipped along with CSDK 2.81.TC3) should =
have
the problem addressed.
Regards,
Kanchana Padmanabhan
Software Engineer
R&D - IBM Data Management Group
11200 Lakeview, Lenexa, KS 66219
Tel: 913 599 8674 t/l : 337 8674 Fax: 913 599 7260
=
nathandeneau@cox. =
net (nate) =
Sent by: =
To
owner-informix-li informix-list@iiug.org =
st@iiug.org =
cc
=
Subj=
ect
04/20/2004 11:17 Why do I lose precision when I =
AM write the results of a sql query=
to
an html report? =
=
Please respond to =
nathandeneau =
=
=
=
Hello All,
I am losing precision when I write the results of a sql query to an
html report. I'm using Informix 7.31 and ASP (IIS 5.0, IE6.0). In
dbaccess, my query returns...
msgtype 210
sos 20246
cos 10
..where msgtype is a "message type", sos is "sum of settle amount" and
cos is "count of settle amount". In ASP, the following code...
Response.Write("<br>");
Response.Write("<br>|"+oRs.Fields("msgtype").value+"|");
Response.Write("<br>|"+oRs.Fields("sos").value.toString().length+"|");
Response.Write("<br>|"+oRs.Fields("sos").value+"|");
Response.Write("<br>|"+oRs.Fields("cos").value+"|");
...returns...
|210|
|3|
|20200|
|10|
The "3" and "20200" should read "5" and "20246"? Why am I losing
precision?
Thanks Much,
Nate
=
--1__=09BBE4EFDFE213388f9e8a93df938690918c09BBE4EFDFE21338
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>I am guessing you are using the IBM Informix Ole DB provider to conn=
ect to 7.31<br>
<br>
The problem seems similar to the one that was reported sometime last ye=
ar.<br>
The Ole DB 2.81.TC3 provider (shipped along with CSDK 2.81.TC3) should =
have the problem addressed.<br>
<br>
<br>
Regards,<br>
Kanchana Padmanabhan<br>
<br>
Software Engineer<br>
R&D - IBM Data Management Group<br>
11200 Lakeview, Lenexa, KS 66219<br>
Tel: 913 599 8674 t/l : 337 8674 Fax: 913 599 7260 <br>
<br>
<img src=3D"cid:10__=3D09BBE4EFDFE213388f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for nathandeneau@cox.ne=
t (nate)">nathandeneau@cox.net (nate)<br>
<br>
<br>
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D09BBE4E=
FDFE213388f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">nathandeneau@cox.net (nate)</font></b><font siz=
e=3D"2"> </font><br>
<font size=3D"2">Sent by: owner-informix-list@iiug.org</font>
<p><font size=3D"2">04/20/2004 11:17 AM</font>
<table border=3D"1">
<tr valign=3D"top"><td width=3D"168" bgcolor=3D"#FFFFFF"><div align=3D"=
center"><font size=3D"2">Please respond to<br>
nathandeneau</font></div></td></tr>
</table>
</ul>
</ul>
</ul>
</ul>
</td><td width=3D"60%">
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D09BBE4EFDFE213388f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D09BBE4EFDFE213388f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">informix-list@iiug.org</font></td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D09BBE4EFDFE213388f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D09BBE4EFDFE213388f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
</td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D09BBE4EFDFE213388f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt=
h=3D"100%"><img src=3D"cid:30__=3D09BBE4EFDFE213388f9e8a93df938@us.ibm.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">Why do I lose precision when I write the results of a =
sql query to an html report?</font></td></tr>
</table>
<table border=3D"0" cellspacing=3D"0" cellpadding=3D"0">
<tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D09BBE4EFDFE2=
13388f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=
=3D""></td><td width=3D"336@@DQ