Home. 
.

transparent

transparent

transparent

Altova Mailing List Archives


Re: Missing a decimal point

From: Ivan@-----------.---------.---
To: NULL
Date: 2/4/2005 10:11:00 AM
Hi, 
Thanks for your comments. Basically (Simplified) it looks like this (VB 
sample): 
    Dim dom As New MSXML2.DOMDocument
    Dim val As Double
    'the xmlfile is <value>2.25</value>    
    dom.Load "C:\Code\Misc\xmlparser\value.xml"
    val = CDbl(dom.Text) 'this returns 225 if the Decimal separator is (,) 
and the group separator is (.)
    To me the question is is there any way in a pure XML to specify the type 
and maybe the used decimal separator... 


"Martin Honnen" wrote:

> 
> 
> Ivan wrote:
> 
> 
> > Recently I had some problems with MSXML misinterpretting numbers with 
> > floating points - when I want to save something like 0.123456 it saves it as 
> > 123456. 
> > It has to do with the locale - some European locales use "," as decimal 
> > separator instead of period "." and this is when the problem happens - looks 
> > like msxml only understands the "." so if we switch back to English locale 
> > the problem is gone. 
> > Is there any other way to fix this problem besides changing the locale back 
> > to US English? Some of our customers are not willing to do this. 
> 
> Can you show us exactly in what way you use MSXML then that problems 
> occurs? Are you using DOM or XSLT? Show us the relevant code, relevant 
> XML input and output.
> I am guessing that you have for instance
>    <data>0.123456</data>
> in some XML input but you need to show what you do then with MSXML when 
> you say "saves it as 12345".
> 
> -- 
> 
> 	Martin Honnen
> 	http://JavaScript.FAQTs.com/
> 


transparent
Print
Mail
Like It
Disclaimer
.

These Archives are provided for informational purposes only and have been generated directly from the Altova mailing list archive system and are comprised of the lists set forth on www.altova.com/list/index.html. Therefore, Altova does not warrant or guarantee the accuracy, reliability, completeness, usefulness, non-infringement of intellectual property rights, or quality of any content on the Altova Mailing List Archive(s), regardless of who originates that content. You expressly understand and agree that you bear all risks associated with using or relying on that content. Altova will not be liable or responsible in any way for any content posted including, but not limited to, any errors or omissions in content, or for any losses or damage of any kind incurred as a result of the use of or reliance on any content. This disclaimer and limitation on liability is in addition to the disclaimers and limitations contained in the Website Terms of Use and elsewhere on the site.

.
.

transparent

transparent