dbTalk Databases Forums  

Values (MASKS)

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Values (MASKS) in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andrew Vinich - Brazil
 
Posts: n/a

Default Values (MASKS) - 04-08-2005 , 10:37 AM






I have two servers in my company with the same regional options.
But when I get a result from a MDX query(in ASP) the result in the first
is (1.000.000,00) and in the other one is (1,000,000.00). They are both in
English!

The line that prints the values:
Response.Write(cellset(j, i).FormattedValue)

What can it be???

Reply With Quote
  #2  
Old   
OLAPMonkey
 
Posts: n/a

Default Re: Values (MASKS) - 04-08-2005 , 10:53 AM






Are you sure that both use a comma for the "Digit Grouping Symbol" and
both use a period for the "Decimal Separtor". The 2 can look almost
the same in the regional settings dialog.

You said
Andrew Vinich - Brazil wrote:
Quote:
I have two servers in my company with the same regional options.
But when I get a result from a MDX query(in ASP) the result in the
first
is (1.000.000,00) and in the other one is (1,000,000.00). They are
both in
English!

The line that prints the values:
Response.Write(cellset(j, i).FormattedValue)

What can it be???


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.