Re: comma as decimal point?
- From: "Evertjan." <exjxw.hannivoort@xxxxxxxxxxxx>
- Date: 12 Jan 2007 15:18:38 GMT
Kim wrote on 12 jan 2007 in microsoft.public.inetserver.asp.db:
I need to be able to write numbers to an Access database using comma
as decimal point like 22,5 (using the comma-sign).
You mean using ASP and the Jet engine?
The above should be named a string, numbers have no points or commas.
usng ASP-vbs:
s1 = "22.5"
s2 = replace(s1,".",",")
usng ASP-jscript:
s1 = '22.5';
s2 = s1.replace(/\./,',');
This won't work, if I use 22,5 it gets rounded up to 23
So why do you need it then?
The field mut be an integer field.
id I use 22.5 (which i can't anyway for other reasons) nothing getsstored at all. ?
Wouldn't it be sensible to show your code, only the offending part please!
--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
.
- Follow-Ups:
- Re: comma as decimal point?
- From: Kim
- Re: comma as decimal point?
- References:
- comma as decimal point?
- From: Kim
- comma as decimal point?
- Prev by Date: comma as decimal point?
- Next by Date: Re: Exec Scheduled Job on SQL Server
- Previous by thread: comma as decimal point?
- Next by thread: Re: comma as decimal point?
- Index(es):
Loading