This topic is locked

Dot turns into comma

2/24/2004 5:12:33 PM
ASPRunnerPro General questions
author

Hello.
I have ha little problem, it shows when I use numbers whith decimals. ex: 14.5

It stores just right in the Access databas, and shown like 14.5 under the list page.

But when I should "Edit" that post the dot has become a comma, som it shows like this under the edit page: 14,5

And if I when tryes to update the post whit that comma, i get error.

But if I change the comma into a dot again it works.

I´v tried almost everything but can´t find the soulotion.

admin 2/24/2004

Erik,
you need to set correct regional settings in ASPRunner ( step 11 of 12 ) to make sure floating point numbers always appear with dot.

501014 2/25/2004

Hi,
I have set the regional settings to English(USA), but it will not work anyway.

It shows right under the list page, but change to an comma in the edit page.

I also have tried to set the Session.LCID directly to the edit page but that has no effect.
Why do I get an error when I from the edit page tries to save the post with a number with comma.

The only time I can use comma is when I set the property to TEXT format in the databas for that field.

But when I changes the Field property to numbers Simple, i got these problems.
When I set the regional settings to Swedish, that is the Regional setting I will use, I get this problem all the time.

Whit the regional setting set to swedish it shows whit an comma in the list page, and also in the edit page, but when I saves the edit whit a comma I get an error, but if I changes the comma to a dot the edit goes thru.
I´m confused.

500083 6/14/2005

I´m having the same problem Eric has..

Has there been shown a solution for this yet?

admin 6/17/2005

Hi,
this error was fixed.
Here is the download link