Re: IBM Informix OLEDB driver bug
Fernando Nunes <spam@domus.online.pt> wrote in message news:<bf258b$acovp$1@ID-161111.news.uni-berlin.de>... > Thomas wrote: > > My code sum a database column whose type is 4 bytes integer > > Select SUM(col1) > > From tbl > > GROUP BY col2 > > ORDER BY col3 > > > > The SUM value can be up to 7 digits. I have it output to a webpage. > > When I looked at the result, I found the sort doesn't work, a small > > number is in between two larger ones. I tried a work around by > > changing my code to > > SELECT SUM(col)*1. Magically I see the right result on my webpage. > > > > I use ADO, OLE drivre is from IBM Informix Connect ver2.81. Informix > > server is IDS9.4 on Solaris. > > > > I also tried to use ASP.NET. Howerve this clause will break with the > > walk around. > > dataAdapter.Fill(dataset, "tbl"). At the end of it long stack list, > > the error is a paramter is missing in a function. Obviously has > > nothing to do with my code. However, with the previous code everything > > is fine, except the previous bug appears again:( > > > > Thanks for any advice, > > And the table schema is...? Create tbl { col1 integer, col2 char(10), col3 char(10) } Thanks
Thomas wrote: > Fernando Nunes <spam@domus.online.pt> wrote in message news:<bf258b$acovp$1@ID-161111.news.uni-berlin.de>... > >>Thomas wrote: >> >>>My code sum a database column whose type is 4 bytes integer >>>Select SUM(col1) >>>From tbl >>>GROUP BY col2 >>>ORDER BY col3 >>> >>>The SUM value can be up to 7 digits. I have it output to a webpage. >>>When I looked at the result, I found the sort doesn't work, a small >>>number is in between two larger ones. I tried a work around by >>>changing my code to >>>SELECT SUM(col)*1. Magically I see the right result on my webpage. >>> >>>I use ADO, OLE drivre is from IBM Informix Connect ver2.81. Informix >>>server is IDS9.4 on Solaris. >>> >>>I also tried to use ASP.NET. Howerve this clause will break with the >>>walk around. >>>dataAdapter.Fill(dataset, "tbl"). At the end of it long stack list, >>>the error is a paramter is missing in a function. Obviously has >>>nothing to do with my code. However, with the previous code everything >>>is fine, except the previous bug appears again:( >>> >>>Thanks for any advice, >> >>And the table schema is...? > > > Create tbl { > col1 integer, > col2 char(10), > col3 char(10) > } > > Thanks order by col3... col3 is a char datatype. As such the order will be alphabetic and not numeric. Regards.