Where get decimals lost?

When I run a script as CGI (WWW/Delphi-CGI/BDE/ODBC/INFORMIX) then decimals are lost: 20,78 will show as 20,00 When I run the same script at the console then decimals come ok. At program time under Delphi decimals are also ok. What could happen at run time (NT 4.0/MS IIS/Informix CLI 2.8)?

Reinhold Staubach wrote: > When I run a script as CGI (WWW/Delphi-CGI/BDE/ODBC/INFORMIX) then > decimals are lost: 20,78 will show as 20,00 > When I run the same script at the console then decimals come ok. > At program time under Delphi decimals are also ok. > What could happen at run time (NT 4.0/MS IIS/Informix CLI 2.8)? I would immediately suspect that the Informix locale settings that work for you at the console don't work for the CGI code under the web server because the environment is not set correctly. I'm not wholly convinced of this explanation, but problems with things working OK from the command line and not from a CGI script or web server environment usually relate to the environment variables that are set, or (mostly) not set, by the web server. On all platforms... -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"

Reinhold.Staubach@verwaltung.uni-regensburg.de (Reinhold Staubach) wrote in <3A19031F.4BAE7DD8@verwaltung.uni-regensburg.de>: >When I run a script as CGI (WWW/Delphi-CGI/BDE/ODBC/INFORMIX) then >decimals are lost: 20,78 will show as 20,00 >When I run the same script at the console then decimals come ok. >At program time under Delphi decimals are also ok. >What could happen at run time (NT 4.0/MS IIS/Informix CLI 2.8)? Hi Reinholt, look for environment variable 'DBFLTMASK' HTH Dirk