FormatNumber

[John Squirrell]

Hi,

In the FrontPage Database Wizard I have the following custom query:
Select *, FORMAT(Number, '#.00') AS fNumber FROM MyFile

In The Access Database I have the Data Type as Number, filed Size Double,
Format 00.00 and Decimal Places set to Auto

When I view the resulting page on my Local Server I get the correct result:
00.00

When I view the page on my remote server I get:
00,00

I also have the following script in my global.asa file:

<SCRIPT RUNAT=Server Language=VBScript>
SUB Session_OnStart
Session.lcid=1033
END SUB
</SCRIPT>

Any help greatly appreciated.

John

 

[MD WebsUnlimited.com]

Hi John,

I would contact your ISP / WPP.

 

[John Squirrell]

Hi Mike,

I have contacted my OSP, OneAndOne, but they seem to be struggling with this
one. They don't offer support at weekends.

If you have an alternative solution it would be greatly appreciated.

Regards

John